On 2020/01/08 2:03 PM, Keith Medcalf wrote:
1. What is it for?
It is a common misspelling of "IS NOT NULL" and means the same thing.
"ISNULL" is also a reserved word as it is a common misspelling of "IS NULL" and
means the same thing.
You will note that ISNOTNULL is not a reserved word because apparently the
common misspellings only omit one or the other of the spaces, butnotboth at the
sametime.
Also, ISNOT is not a reserved word. Apparently it is more common for the
misspelling IS NOTNULL to be made than ISNOT NULL, even though ISNOT is the
more logical inverse operator to IS. (Perhaps this is because ISNOT could be
spelled as iSnot leading to lawsuits from Apple ... :) )
LOL - I'm quoting you in the docs. :)
Thanks for clarifying,
Cheers!
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users