Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL functions » Alphabetical list of functions

 

NULLIF function [Miscellaneous]

Provides an abbreviated CASE expression by comparing expressions.

Syntax
NULLIF( expression-1, expression-2 )
Parameters
  • expression-1   An expression to be compared.

  • expression-2   An expression to be compared.

Remarks

NULLIF compares the values of the two expressions.

If the first expression equals the second expression, NULLIF returns NULL.

If the first expression does not equal the second expression, or if the second expression is NULL, NULLIF returns the first expression.

The NULLIF function provides a short way to write some CASE expressions.

See also
Standards and compatibility
  • SQL/2003   Core feature.

Example

The following statement returns the value a:

SELECT NULLIF( 'a', 'b' );

The following statement returns NULL.

SELECT NULLIF( 'a', 'a' );