Update Query Case Statement
Use the following update query to check for a specific condition on a particular column to update the value.
update Email_TBL set emailcc = case when nullif(emailcc,'') is null then '[email protected]' else ';[email protected]' end
Case When Statement in Update Query. was last modified: February 21st, 2017 by