SQL 2000: Change all values of a column to 0 where the value is currently NULL
Posted on 2007-03-23
I have a table entitled insurance_details_tbl that contains several float columns - I woult like to change all values in each column that are NULL to 0.
I have the below query (doing it column by column currently), which executes without error but changes nothing:
SET value_computer = 0
WHERE (value_computer = 'NULL')