Null or empty check for a string variable

Question

if((isnull(@value,''))='')

I want to know whether the above piece of code works in checking if the variable is null or empty.

Answer 1

Yes, that code does exactly that.

You can also use:

if (@value is null or @value = '')

Edit:

With the added information that @value is an int value, you need instead:

if (@value is null)

An int value can never contain the value ''.