Replace NULL with empty string Due to precedence set within my organization, I need to replace NULL values in certain columns (roughly 15-20) with the empty string. While the solution comes quite easily in more traditional languages, I'm struggling with how to do this in T-SQL. Can anybody point me in the right direction? Much appreciated.
Not an expert SQL Server guy. However, Since Microsoft haven't made the same mistake as Oracle where the empty string and NULL are considered the same, this should work:

UPDATE TableName
SET My_String = '' 
WHERE My_String IS NULL 
AND Other_Conditions;