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