# 1981 Manual Shows Incorrect Example for Optimizing Case-Insensitive Column Comparisons

---

The help file says the following:

"SELECT *
FROM customer
WHERE (UPPER(State)='CA')

In this query, DBISAM will be able to select and use the case-insensitive index on the State field, and this is caused by the presence of the UPPER() function around the field name."

It appears that the help file is wrong.