Re: Case Insensitve Text Searching

From: Steve Corbett <stevec_at_fcs.wa.gov.au>
Date: 1997/05/21
Message-ID: <3382B022.3B83@fcs.wa.gov.au>#1/1

Bola Ogunlana wrote:
>
> In article <5li5ga$2sj_at_client2.news.psi.net>, Brad Pliner
> <brad_at_iliad.com> writes
> >
> >What's the best way to do case insensitive text searching?
> >
> >Here's what I'm considering:
> >Suppose I'm searching the names of movies. I'm create a field for the name,
> >as it will be displayed to the user "The Long Kiss Goodnight". Additionally
> >I'll create a field for the name, all capitalized, and strip out all
> >instances of "the", "of", etc. ("LONG KISS GOODNIGHT"). I'll use that field
> >to search by.

why bother stripping out the 'of' etc?
store the name in upper case in the database, change to a mix of case for display if required.

> You could possible try using the "Upper" or "Lower" functions instead.
> eg if you want to search for "search_string" you'll do something like;
>
> select name from movies where upper(movie_name) like
> upper('%&search_string%');

me thinks this will invalidate index usage? Received on Wed May 21 1997 - 00:00:00 CDT