--- In firebird-support@yahoogroups.com, "ra8009" <ra8009@y...> wrote:

> Is there a way to turn off case sensitivity when running a query with
> a WHERE clause like this:
>
> WHERE FIRST_NAME LIKE('j%')

I can think of 2 ways

WHERE UPPER(FIRST_NAME) LIKE 'J%'

WHERE FIRST_NAME LIKE 'j%' OR FIRST_NAME LIKE 'J%'

I am not sure if the first method is able to use any index you may
have available on the First_Name field. FB 2 (alpha) allows you to
create an index that could be used in the first method.

Adam