Subject RES: [firebird-support] Re: soundex
Author Adam
--- In firebird-support@yahoogroups.com, "Andre Fogelman" <andre@a...>
wrote:
>
> 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.
>
> Thank you
>

That must be the Firebird 2 bit. Firebird 1.5 doesn't like the
parameter inside the substring. You could try rigging up an execute
statement call, I might take a look at back porting this later.

Adam