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.

Thanks.

From,
Carlos Yu
developer@...