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

In addition to making your search column upper-case, I would strip out all spaces and non-alpha characters. This makes searching even easier.

JJ

Jeffrey Wilkinson wrote in message <37856141.0_at_news.atrax.net.au>...
>I'm looking for a good way to record key values that invlove upper/lower
case
>characters. I need to be able to order and search the key columns in a
case
>insensitive way.
>
>For example, I record the First and Surnames for people. I want to be able
to
>record the names in the format that they are to be displayed (e.g, Mr Peter
>McAlistair) but I want to be able to index and search the information so
that
>the case is irrelevant. The only way that I can think of now is to have
one
>column to record the display value and then a second column to record the
>value that is to be searched and indexed.
>
>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.
>
>Any suggestions will be greatly appreciated.
>
>Jeff
Received on Sun Jul 11 1999 - 16:45:33 CDT