Reported By: Danny Humphress Reported On: 1/26/2006 For: Version 4.22 Build 4
# 2159Using an ESCAPE Character in the Middle of a LIKE Constant Confuses Optimizer The problem is the following is not optimized but it should be:
WHERE UPPER(MyField) LIKE UPPER(‘ABC/%DEF%’) ESCAPE ‘/’
ResolutionFixed Problem on 1/28/2006 in version 4.22 build 5
Products AffectedDBISAM Additional Software and Utilities DBISAM ODBC Client-Server DBISAM ODBC Client-Server with Source DBISAM ODBC Standard DBISAM ODBC Standard with Source DBISAM VCL Client-Server DBISAM VCL Client-Server with Source DBISAM VCL Standard DBISAM VCL Standard with Source