# 285 UPPER 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.