Re: Advice on storing Upper/Lower case Key values then doing case insensitive searching; Phonetic matching.

Jeffrey Wilkinson wrote in message <37856141.0_at_news.atrax.net.au>...

>Also, I'm looking for some utilities that will enable the generation of
>phonetic keys so that, for example, Smith, Smythe, and Smit are regarded as
>similar names.

I think there is a function called soundex which may help with this.

As for your main problem, it looks like your original idea of having a separate field with values which are to be searched on sounds the best. Oracle 8 may have some additional index functionality for storing the index in caps even if the field is mixed case.

M Received on Fri Jul 09 1999 - 02:54:11 CDT