Posted by BF on 12/18/06 20:50

Hi,

I have some tables where I import data in, lots of field have gotten a
NULL value which the application can not handle.

Now can I replace each NULL value with '' in a columns with:
update <table> set [<column>] = '' where [<column>] IS NULL

But because there are lots of columns this is pretty much work, also
there are multiple tables.

Is there an easy way to replace all NULL values in all columns in a
table?

Thanks in Advance
Bob

• Next in forum: Re: Help-Can I use 4 GB memory by SQL Server2000?
• Prev in forum: Help-Can I use 4 GB memory by SQL Server2000?
• Thread view: Replacing NULL value in multiple columns in a table

[Reply to this message]