Azure Data Factory - How to initialize variable with null value

Question

I am calling a stored procedure from the Azure Data Factory. And part of one parameter I need to pass Null. However, the problem is, if I set null, it takes "Null" as a string.

Is there a way I can initialize a variable with null?

Answer 1

You can pass a NULL value to a Stored Procedure from the Stored procedure activity using the "Treat as null" checkbox:

It seems that the real question though is how to set a Variable's value to NULL. The only way I can see right off the bat is to (mis)use the coalesce function:

NOTE: I have not tested this, so YMMV.