I do not understand why you wish to do this to values in a table and not in the T-SQL statement which selects the data from the table, but you could look at this to understand the ISNULL function, which you could then use in a update statement.
[http://technet.microsoft.com/en-us/library/ms184325(SQL.90).aspx/url]