Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
DBISAM Technical Support
»
Incident Reports
»
Incident Reports Addressed for Version 1.10
»
View Incident Report
View Incident Report
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
The cause of this problem was that the expression evaluation engine was not using the proper NULL comparison when doing a LIKE.
Resolution
Fixed Problem on 2/7/1999 in version 1.10 build 1
More Support Options
Search Incident Reports
Support Forums
Frequently Asked Questions
Technical Bulletins
Technical Articles
Product Manuals
Roadmap