Hi
how to update column if two column is null or empty.
UPDATE tHLIntimationLetter_Cust SET UD_RejectionReason =
(CASE WHEN ( UD_Category2='Null') and ( Address1='Null') then
'COMMUNICATION & BUSSINESS ADRESS IS NOT FOUND' end)
FROM tHLIntimationLetter_Cust B
when I using this wrong updating