Reported By: Lawrence Lustig Reported On: 2/8/1999 For: Version 1.09 Build 1
# 285UPPER and LOWER Functions in SQL Causing Access Violations I'd still like to see a database or query level IgnoreCaseInSQL setting (just for filters). But failing that, I tried the above technique, but the following SQL:
SELECT t2.FileID, t1.FirstName, t1.LastName
FROM people t1, claims t2 WHERE t1.PeopleID = t2.PeopleID
AND UPPER (FirstName) LIKE "C%"
gives an Access Violation in Delphi and DBSYS.
CommentsBoth the upper and lower function were trying to evaluate arguments that did not exist.
ResolutionFixed Problem on 2/8/1999 in version 1.10 build 1