Replace NULL with empty string
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;