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

Home -> Community -> Usenet -> c.d.o.server -> Re: Advice on storing Upper/Lower case Key values then doing case insensitive searching; Phonetic matching.

From: Gerry Sinkiewicz <sinkiege_at_snet.net>
Date: Sat, 10 Jul 1999 12:38:27 -0400
Message-ID: <7m7sqp$qqu@news1.snet.net>

Oracle has a soundslike function to handle smythe smith etc.

Your idea about two columns seems ok but if you search with upper(table_col) like upper(your value%)
it maybe ok (depends on volume of data etc.). Your idea is probably better.

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
>

text snipped here

>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 Sat Jul 10 1999 - 11:38:27 CDT