Case Insensitve Text Searching

From: Brad Pliner <brad_at_iliad.com>
Date: 1997/05/16
Message-ID: <5li5ga$2sj@client2.news.psi.net>#1/1

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.

Any thoughts? Is this the best way to do this?

• Brad

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_

 Bradley S. Pliner           mailto:brad_at_pliner.com       Internet Software
 Pliner Products             http://www.pliner.com/       Custom Development

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Received on Fri May 16 1997 - 00:00:00 CDT