Subject Using Filter with IBODataset
Author mspencewasunavailable
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"
from cust
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.