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


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: Jul 22 2021
Copyright © 2021 Thunderstone Software LLC. All rights reserved.