Subject RE: [firebird-support] Re: soundex
Author Si Carter
> -----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