Beastmode Case Statement with NOT IN operator

DMJerry

MarkSnodgrass

You might need to provide more detail, but if you are wondering if you can do this, the answer is yes. The syntax would look like this:

CASE WHEN fieldname NOT IN ('Georgia','Alabama','Texas') THEN 'exclude' ELSE 'include' END

MarkSnodgrass

You might need to provide more detail, but if you are wondering if you can do this, the answer is yes. The syntax would look like this:

CASE WHEN fieldname NOT IN ('Georgia','Alabama','Texas') THEN 'exclude' ELSE 'include' END

DMJerry

Thank you but it literally started working after I posted it so I tried to delete my post and could only delete the context and not the post. No clue but it's working.

Thank you @MarkSnodgrass