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
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:
NOTES
COMPATIBILITY
SQL-92 Compatible
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |