Re: string case insensitive comparisons with Oracle

From: kdc <kcameron_at_navicsys.com>
Date: 2000/04/26
Message-ID: <jTIN4.167675$AT6.240408@dfw-read.news.verio.net>#1/1

It would be a very horrible price to pay in general but for certain situations you could use the Oracle ConText Cartridge (Intermedia Text in 8i).

This option supports case insensitive searches, soundex etc. Not suitable in many situations but useful in others.

Kirk

<willmccormick_at_my-deja.com> wrote in message news:8e737a$8uj$1_at_nnrp1.deja.com...
> 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 Wed Apr 26 2000 - 00:00:00 CDT