How to: |
The NULLIF operator returns NULL if its two arguments are equal. Otherwise, the first argument is returned.
NULLIF(arg1, arg2)
where:
Any type
Are data values. The types of the two arguments must be compatible.
This operator returns the compatible type of the arguments.
NULLIF operator returns NULL if two values are equal. This example,
NULLIF(IDNUM, -1)
returns NULL if the identification number is -1, otherwise it returns the number.
iWay Software |