![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 SQL Manual » Conversion Functions » IFNULL |
IFNULL(<Expression> THEN <Expression> ELSE <Expression>) IFNULL(<Expression>, <Expression>, <Expression>) <Expression> = Type of: CHARACTER|CHAR CHARACTER VARYING|VARCHAR GUID BYTE BYTE VARYING|VARBYTE BINARY LARGE OBJECT|BLOB CHARACTER LARGE OBJECT|CLOB BOOLEAN|BOOL SMALLINT INTEGER|INT BIGINT FLOAT DECIMAL|NUMERIC DATE TIME TIMESTAMP INTERVAL YEAR INTERVAL YEAR TO MONTH INTERVAL MONTH INTERVAL DAY INTERVAL DAY TO HOUR INTERVAL DAY TO MINUTE INTERVAL DAY TO SECOND INTERVAL DAY TO MSECOND INTERVAL HOUR INTERVAL HOUR TO MINUTE INTERVAL HOUR TO SECOND INTERVAL HOUR TO MSECOND INTERVAL MINUTE INTERVAL MINUTE TO SECOND INTERVAL MINUTE TO MSECOND INTERVAL SECOND INTERVAL SECOND TO MSECOND INTERVAL MSECOND
Same as input
SELECT TransDateTime, IFNULL(Amount THEN 0.00 ELSE Amount) AS Amount FROM Transactions
Deviation | Details |
Extension | This function is an ElevateDB extension. |
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |