Re: Function for SOUNDEX
There is Soundex information in the contributions section of the IIUG website.
Never looked at it myself, but I've seen it there. It won't be as transparent
as that, but then again I don't remember SOUNDEX as being part of the SQL
standard (then again, I'm not all that familiar with the ins and outs of
unimplemented (by Informix) SQL92).
http://www.iiug.org/
HTH
-Richard
On 5 Jun 1997, Sameer Bhatia 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
>
>
>