Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Case Insensitve Text Searching
Brad Pliner wrote:
>
> 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
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> -
Try ConText option. That will do the work.
ben Received on Wed May 21 1997 - 00:00:00 CDT
![]() |
![]() |