Thank you I will give it a try and report back

-----Mensagem original-----
De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de Si Carter
Enviada em: terça-feira, 15 de novembro de 2005 07:58
Para: firebird-support@yahoogroups.com
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 (http://www.fbtalk.net/viewtopic.php?id=182)

HIH

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://www.tectsoft.net/ - Homepage




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links