Icon View Incident Report

Serious Serious
Reported By: Lawrence Lustig
Reported On: 2/7/1999
For: Version 1.09 Build 1
# 282 SQL LIKE Operator Not Working Properly

It seems that this select returns nothing:

SELECT * FROM Claims WHERE InjuryDesc LIKE "%b%"

There is a record that sould match, it has InjuryDesc = 'Abdomen'. The select:

SELECT * FROM Claims WHERE InjuryDesc LIKE "AB%"

does find this record.

Comments Comments
The cause of this problem was that the expression evaluation engine was not using the proper NULL comparison when doing a LIKE.

Resolution Resolution
Fixed Problem on 2/7/1999 in version 1.10 build 1