View Single Post
  #4 (permalink)  
Old December 1st, 2005, 06:33 AM
ChrisScott ChrisScott is offline
Friend of Wrox
 
Join Date: Jul 2003
Location: , , United Kingdom.
Posts: 683
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hey David,

If you have some sort of field unique in your table, you could do something like...
Code:
UPDATE myTable SET myField = 'myValue' WHERE myUniqueField IN(SELECT TOP 1 myUniqueField FROM myTable [criteria here]);
HTH,

Chris

Reply With Quote