Progress
SQL-92
Guide and Reference


NULLIF Function

Returns a null value for expression1 if it is equal to expression2. It is useful for converting values to null from applications that use some other representation for missing or unknown data. The NULLIF scalar function is a type of conditional expression.

SYNTAX

NULLIF ( expression1, expression2 ) 

EXAMPLE

This example uses the NULLIF scalar function to insert a null value into an address column if the host-language variable contains a single space character:

INSERT INTO employee (add1) VALUES (NULLIF (:address1, ’ ’)); 

NOTES

COMPATIBILITY

SQL-92 Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095