I have a case statment and I need to assign a value depending on the given value or nothing.
SET e.ModifiedBy = CASE WHEN ID=' AND
ATN=' THEN e.ModifiedBy
ELSE ? END, --else I do not want to put anything.
So if the first part of the case statement is true then assing a value else do not assing anything else.
i am a novice and a student
View Complete Post