isNull

Tests a value, and returns a long value of 1 if NULL, 0 if not. Syntax:

   isNull(testVal)

    SELET isNull(myColumn) FROM myTable;

Added in version 7.02.1405382000 20140714. Note that SQL NULL is not yet fully supported in Texis (including in tables). Also note that Texis isNull behavior differs from some other SQL implementations; see also ifNull.


Copyright © Thunderstone Software     Last updated: Apr 26 2017
Copyright © 2017 Thunderstone Software LLC. All rights reserved.