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