IIUG Software Repository Files

Subject: Function for SOUNDEX
From: Andrew Foster <afoster@www.uni-com.co.uk>
Newsgroups: comp.databases.informix
Date: Fri, 06 Jun 1997 18:54:20 +0200

--------------226F3049229E1F439960EF17
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I worked on a project in Illustra which required similar functionality
to what you are describing.  I ended up adapting a C function to provide
my solution, from which i'm sure you can adapt it into whatever form you
require.

Sameer Bhatia (Contract) wrote:

> Hi Folks,
>
> Oracle has a function SOUNDEX. This function has the ability
> to find words that sound like other words, virtually
> regardless of how either is spelled.
>
> For example,
> consider a table weather, with columns : city, temperature
> and condition.
>
> SELECT * from weather
> WHERE SOUNDEX ( city) = SOUNDEX ('Sidney')
>
> The result will be
>
> CITY             TEMPERATURE              CONDITION
> ---------------------------------------------------------------------------
>
> SYDNEY                                29
> SNOW
>
> I am working on porting of an application on Oracle to
> Informix and the current application has quite a few
> instances of SOUNDEX.
>
> Wondering whether a function (stored procedure) can be
> written in Informix which would provide the same
> functionality as of SOUNDEX in oracle.
>
> Any help would be appreciated.
>
> Sameer

--

Andrew Foster
afoster@www.uni-com.co.uk
---------------------------------------------------------------------
Unique Communique Group
Unit 10, Parkway 4, Fourways, Trafford Park, Manchester, M17 1SN.
UK.
Tel. : +44 (0)161 877 2055                 Fax. : +44 (0)161 877 9649

--------------226F3049229E1F439960EF17--