When I set case-insensitive on a TIBOQuery, then set the filter string
to this:

Filter := 'CUST."Last Name" starts with '''A'''';

I get the following in the monitor output:

select cust."Last Name", cust."First Name",
<< many fields removed>>..., cust."Picture"
, CUST.RDB$DB_KEY
from cust
WHERE (
cust."Cat" = ? /* PRM_0 */
or ? /* PRM_1 */ = 99
)
AND (UPPER( CUST."Last Name" )
starts UPPER( with ) AND 'A')

Thought you'd like to know.

Michael D. Spence
Mockingbird Data Systems, Inc.