Subject Re: [firebird-support] Metaphone UDF
Author M Tuttle (KS)
Greetings Daniel,

I followed an article called "Implementing a Soundex Function" By John
Midwinter
It can be found on the IBPhoenix website
http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1086159161%3A486930&page=ibp_howto4

I created the dll in Delphi as talked about in this article, placed the dll
in the UDF folder and it works great.

I can then use this in my Delphi source as in the following:
'P.LAST_NAME_SB = GETSOUNDBYTES(' + QuotedStr(sLastName) + ')';

or I can use it in FireBirds stored procedures and triggers in the database
as in:

DECLARE VARIABLE iSoundBytes SmallInt;
begin
iSoundBytes = GETSOUNDBYTES(V_ADDRESS1_UPR);
...
end

Check it out. Hollar if you need any assistance.

Mike




----- Original Message -----
From: "Daniel L. Miller" <dmiller@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, January 08, 2005 3:09 PM
Subject: [firebird-support] Metaphone UDF


>
> Does anyone have/know of a metaphone UDF for Firebird?
>
> --
> Daniel
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>