isNull

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

isNull(testVal)

SELECT 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: May 19 2023
Copyright © 2023 Thunderstone Software LLC. All rights reserved.