Blanks

[wal50]

Some records have a field that contains a blank. All these records need to
get the same value in that field but Find/Replace doesn't seem to work with
"""", " ", null. A null query finds them all. How do I fill these fields
with a value?

Thanks.

 

[Mike Labosh]

Some records have a field that contains a blank. All these records need

to
get the same value in that field but Find/Replace doesn't seem to work
with
"""", " ", null. A null query finds them all. How do I fill these fields
with a value?

UPDATE YourTable
SET YourColumn = YourValue
WHERE YourColumn IS NULL

 

[wal50]

Thanks. All done.

wal50

UPDATE YourTable
SET YourColumn = YourValue
WHERE YourColumn IS NULL
--
Peace & happy computing,

Mike Labosh, MCSD
"I have no choice but to believe in free will."