ifNull

Substitute another value for NULL values. Syntax:

ifNull(testVal, replaceVal)

If testVal is a SQL NULL value, then replaceVal (cast to the type of testVal) is returned; otherwise testVal is returned. This function can be used to ensure that NULL value(s) in a column are replaced with a non-NULL value, if a non-NULL value is required:

SELECT ifNull(myColumn, 'Unknown') FROM myTable;

Added in version 7.02.1405382000 20140714. Note that SQL NULL is not yet fully supported in Texis (including in tables). See also isNull.