Manuals/calci/NULLIF

NULLIF(Value,Default)

• $Value$ and $Default$ is any string.

Description

• The NULLIF function returns a value with the type of the first argument or NULL.
• This function accepts exactly two arguments.
• Here two expressions to be compared.
• If the first argument is not equal to the second one, the NULLIF function returns the first argument.
• In case both arguments are NULL, the NULLIF function returns a NULL value.

Examples

1. NULLIF(25, 25) = 25
2. NULLIF('Hello', 'Hello') = Hello
3. NULLIF('Hello', 'world') = Hello

See Also

• IFNULL
• IF
• UPPERCASE

References

• Nullif

• List of Main Z Functions

• Z3 home