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: Jun 15 2022
Copyright © 2022 Thunderstone Software LLC. All rights reserved.