Query to convert zero lenght string to Null

  • Thread starter Thread starter Kevin Farrell
  • Start date Start date
K

Kevin Farrell

We have a table with a large number of text fields. Is there an easier way
to convert all zero length strings to a Null other than by doing an Update
query and adding each field to the grid?
 
We have a table with a large number of text fields. Is there an easier way
to convert all zero length strings to a Null other than by doing an Update
query and adding each field to the grid?
Click to expand...

Hm. Don't know if it would be harder or easier, but you could create a
new table with fields with Allow Zero Length = False, Required = False
and run an Append query to migrate the data into this table.

Having "a large number of text fields" raises a red flag anyway: if
you have more than some 30 fields in a Table it's probably not
properly normalized!
 
Back
Top