Replace NULL cells in a table for all cells with NULL value

[JackBurton07]

Hi all,

what is the sql to replace all cells in a table taht contain NULL's?

I want to do this in one query: at present I have to write a query for each column

Thanks

JB

 

[BigRed1212]

Why do you want to do that?

 

[fneily]

First, replace Null with what?
Second, a well structured table shouldn't have a bunch of empty cells. Are your tables normalized? You might want to post your table structure(field names/column headings). You might want to read this:

Fundamentals of Relational Database Design

http://r937.com/relational.html

 

[JackBurton07]

its a data migration - the migrated fields in the staging db all contain nulls from the import and I want to place a value in the NULL's so that the next stage of the migration isnt affected by them.

 

[JoeAtWork]

Not sure if this will work, but maybe something like:

UPDATE MyTable SET Field1 = Nz(Field1,"DefaultValue1"),
Field2 = Nz(Field2, "DefaultValue2")

etc.