Marketing Cloud SQL If Statement

Question

I want to assign a Yes or No to a column based on if another variable is Blank or not.

Would it be something like this?

if OpenedDate is Empty then

set Opened = No

if OpenedDate is NotEmpty then

set Opened = Yes

Answer 1

You need to use a CASE statement in order to accomplish this. So something like:

CASE WHEN OpenedDate IS NULL THEN 'No' ELSE 'Yes' END AS 'Opened'