Query to convert zero lenght string to Null

[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?

 

[John Vinson]

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?

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!