At 05:39 AM 18/07/2006, you wrote:

>hi
>can any of you tell me why i get an 'invalid escape sequence' error
>when trying to execute this procedure:
>
>CREATE PROCEDURE GET_NEXT_20_LI_ASTERM (
> "TERM" varchar(240) character set unicode_fss,
> idin bigint)
>returns (
> id integer)
>as
>begin
> for select first 20 id from dicentries where asterm like '\\\' ||
>:term || '\\\' escape '\\\'
> and id > :idin order by id ascending into :id do
> suspend;
>end

Multiple characters in the escape sequence?

./heLen

p.s. Why not use CONTAINING?