Subject Re: [firebird-support] quick question
Author Helen Borrie
At 05:39 AM 18/07/2006, you wrote:
>can any of you tell me why i get an 'invalid escape sequence' error
>when trying to execute this procedure:
> "TERM" varchar(240) character set unicode_fss,
> idin bigint)
>returns (
> id integer)
> for select first 20 id from dicentries where asterm like '\\\' ||
>:term || '\\\' escape '\\\'
> and id > :idin order by id ascending into :id do
> suspend;

Multiple characters in the escape sequence?


p.s. Why not use CONTAINING?