I think that will only match the TOP 2 lnkey's and hence only return those values.  I was looking at this last night and having a great deal of difficulty. ...

Can you post your code?  This should work, but there may be something a second set of eyes might catch.  [You may want to look at a Trigger for Update and...

You betcha.  I just hope someone else has used this method and has some values to populate your table.  That could end up being a long, long list....

Ooops.  I just thought about this and you will have to do a bit more coding on the update to split each word up.  You should be able to do...

I would recommend a function.  You can use that to fix your current data and then call it in your code to fix spelling errors from the front-end when the...

Ron_k, I tried this using a #TempTable (and dropping tblCase since I did not know the data and it looked to be a simple join with a where clause) and...

tblclinical_record_master.clrec_sysid is the problem.  It is unique, yet you are using it in the GROUP BY.  Think in terms of using your current SELECT as a sub-select and get the...

Frank, I recently had the opportunity to try this on a machine that did not have SP3a.  Got the same results... 

Look at this posting:  "Need trigger to split 1 filed to 4 (Pages 

Interesting Remi.  Someone else, (I cannot remember who - probably Frank) posted a better direction for my function in its original form and now you have given me another approach.  I...

This is based upon a table called "AP" with an InvoiceNum field and an update to a CleanInvoiceNum field.  See if this will help you. 

(Generally, Invoice checking like this...

Hopefully not, but either way it taught me something...

My head is not in the game on this one!    I was rushing out of work and again, misread the posting.  You are...

Without a WHERE statement, I think you would be UPDATing the entire table...

If you pass a value, (even a NULL) to table, then the DEFAULT set on the table will not fire.  In other words, TableA has [id], [text], [date] with a DEFAULT...