Hi Carlos

I've had some good results using a collation - eg

MY_CASE_INSENSITIVE_COLUMN VARCHAR(6) DEFAULT '' NOT NULL COLLATE EN_US;

but I don't really know why this seems to work or if there are any downsides. Maybe others would like to comment.

HTH, Andy.

----- Original Message -----
From: "Carlos Yu" <cyware_2000@...>
To: <ib-support@yahoogroups.com>
Sent: Sunday, May 20, 2001 8:08 AM
Subject: [ib-support] Case Insensitive


>
> 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@...
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/