Reported By: Larry Lustig Reported On: 2/17/1999 For: Version 1.11 Build 1
# 309IS NOT NULL SQL Operator Is Not Working Properly Typing either of the following two SELECT commands into DBSYS:
SELECT * FROM Claims WHERE RefByAttorneyID IS NOT NULL
SELECT * FROM Claims WHERE RefByAttorneyID IS NULL
returns the same result set -- the one for the second statement (that is, both SELECTS return the one record in which RefByAttorneyID is in fact set to NULL).
CommentsProblem was with the IS NOT NULL operator. This problem did not affect filters, only queries.
ResolutionFixed Problem on 2/17/1999 in version 1.12 build 1