At 10:01 AM 16/01/2003 +0100, Martijn Tonies wrote:

> > actually you define the _field_ with a case-insensitive collation order.
> > Or you may embed a collate clause into an order by clause I believe.
> > Perhaps even into a where clause?
>
>Dunno :)

Yes, you can do

where last_name collate <collation_order> = :myParam

and

order by last_name collate <collation_order_1>, First_name collate
<collation_order_2>

>I can't find a clear list of case insensitive collation orders, let alone if
>they work for a WHERE clause as well.

They are listed in the releasenotes of Dave Schnepper's latest beta, here:
http://www.brookstonesystems.com/ibCollate3.html

You can download the latest ones at the same site.

cheers,
heLen