Re: case insensitive indexes?

In <3r0dde$lf8_at_spot.YKnet.yk.ca> "Mike Kohut, NorthwesTel" <mkohutnw_at_yknet.yk.ca> writes:

>As a suggestion...
>How about if you create a duplicate field in your database table
>that contains an uppercase-only version of the mixed-case field,
>then create an index on the uppercase field? You would have to
>modify your applications to ensure that the uppercase field is
>inserted or modified in parallel with the mixed-case field.

You should be able to implement that through triggers and have minimal impact on existing applications.

-- 
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!