@STRCMPNULL

Use the @STRCMPNULL in the same way as @STRCMP function to compare two character columns or literal strings, but if the arguments are NULL, the result value is 0 instead of NULL.

Syntax

@STRCMPNULL (<string1>, <string2>)

<string1>

The first column or literal string to be compared.

<string2>

The second column or literal string to be compared.