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:

    SELET 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.


Copyright © Thunderstone Software     Last updated: Jun 9 2017
Copyright © 2017 Thunderstone Software LLC. All rights reserved.