UPDATE TABLE1 SET COL4 = CASE COL1 IS NULL AND COL2 IS NULL THEN NULL ELSE 'New Value' END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)