So, I ran into an strange problems today. I have a MS SQL database column which contains some NULL values. So, I wanted the calls with a NULL value to go in one direction while the calls without a NULL value to go another. Inside a IF NODE I tried:

Variable = “” or Variable = ” ” or Variable = “NULL” or Variable = NULL

None of those worked. At the end just putting the Variable by itself inside the IF node worked. I guess it makes sense, but when dealing with NULL values it can be tricky at times and behavior might vary.

~david