Michael wrote:

> 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.

Yes, absolutely.

Will you please provide a simple sample application I can work with to save
me the time to put one together?

Jason