ChrisM@Work (8/17/2012) HowardW (8/17/2012)
This sounds a really simplistic question, but based on what you've said, it should just be:
update xys set submitdate=NULL where id in ('1','2'.........'100')
I feel I must be missing something as surely if you know how to set the rows to one value, you know how to set it to another...
If I could find an emoticon for perplexed, it would be right here!
Let me guess: OP has closed the window with the list of real id's he updated
... where id in ('1','2'.........'100')
Now he tries to get it back from us...
My question was: would the query SELECT * FROM orders WHERE SubmittedDate = '20120202' return 100 records or else?
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)How to post your question to get the best and quick help