Need to replace empty fields with dash

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I've got a fairly large table with a large number of fields that are empty.
I need to replace the empty fields with a dash. Is there an easy way to do
this? Find/replace doesn't seem to work with spaces.

Thanks,

Jim
 
Jim said:
I've got a fairly large table with a large number of fields that are
empty. I need to replace the empty fields with a dash. Is there an
easy way to do this? Find/replace doesn't seem to work with spaces.
Click to expand...

Interesting: you can use the Find dialog to find them (by specifying
Null in the "Find What" box), but you can't use the Replace dialog to
replace them.

I'd run a series of update queries for this, one for each field. Each
query would have SQL modeled along these lines:

UPDATE TableName SET FieldName = '-'
WHERE FieldName Is Null;

You'd replace "TableName" and "FieldName" with the names of your table
and field.
 
Back
Top