Subject RES: [firebird-support] Re: soundex
Author Andre Fogelman
Thank you I will give it a try and report back

-----Mensagem original-----
De: [] Em nome de Si Carter
Enviada em: terça-feira, 15 de novembro de 2005 07:58
Assunto: RE: [firebird-support] Re: soundex

> -----Original Message-----
> I tried to create the procedure but I get an error on the following
> line:
> vCurrChar = CAST(SUBSTRING(ipWORD FROM :vidx FOR 1) AS CHAR(1));
> I do not have enough knowledge to correct it.

I've added a version of the proc which uses SUBSTR UDF and can be used with
FB versions prior to 2, it can be downloaded from the files section or
copied directly from the topic (


Si Carter - Web Based Firebird Forum - Homepage


Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Yahoo! Groups Links