Re: string case insensitive comparisons with Oracle

what are you trying to accomplish/avoid?

one answer would be to store everything in UPPER- use a trigger on insert or update...

randy

willmccormick_at_my-deja.com wrote:

> Is there a way with Oracle to have string comparisions be cas
> insensitive without using LOWER, UPPER or INDEX Functions?
>
> Sincerely,
>
> William McComick
>
> P.S. Please ignore this if my previous message went through. :]
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue May 02 2000 - 00:00:00 CDT