Hi Carlos!

Yes, LIKE is case sensitive and the only way I know to force case
insensitivity if you need to use LIKE, is to ensure that all information is
stored UPPER- or lowercase (you can add another field for the UPPERCASE
equivalent of the column in question, and fill it in a trigger - use it
only for WHERE clauses, don't display it to your users).

However, there is an almost equivalent statement which is not case
sensitive: CONTAINING.

SELECT * FROM TABLE_CUSTOMERS WHERE LAST_NAME CONTAINING 'xx'

isn't case sensitive, but it will return any records containing xx, not
just those having it in the first two positions.

Set

>Hi,
>I recently started using IB6.01 Open Source and was wondering how to
>force case insensitive queries in a LIKE statement:
>i.e. SELECT * FROM TABLE_CUSTOMERS WHERE LAST_NAME LIKE 'xx%'
>I just noticed that Interbase is case sensitive when using LIKE.