View Single Post
  #3  
Old April 28th, 2004, 05:10 PM
Tim Ferguson
external usenet poster
 
Posts: n/a
Default Copying Data from 1 field to multiple fields?

"Ruth Whitelaw" wrote in
:

I have filtered records and want to copy a particular bit
of data to thousands of rows, where this field is
presently blank.


UPDATE MyTable
SET MyField = "Something"
WHERE MyField IS NULL


Hope that helps


Tim F