How can I enter Null in a blank field

[elentz]

How would I enter a Null in a blank field from a query. I have several fields in a table that may or maynot have information in them. I need to export all those fields, I want to have all the blank fields filled with Null so that when I export the table info I can change the Null to another value.

sugggestions

Thanks

 

[r937]

update yourtable
   set col1 = NULL
 where trim(col1) = ''

lather, rinse, and repeat



r937.com | rudy.ca

 

[elentz]

Thanks That got it
1