On 7-8-2012 20:34, red_october2009 wrote:

> Solution found: Just chop off the last character from the BLOB to be inserted, before doing the REPLACE()
>
> Example:
>
> vCHT_TXT = SUBSTRING(:vCHT_TXT FROM 1 FOR CHAR_LENGTH(vCHT_TXT) - 1);
>
> ... Then do your REPLACE()

What is your Firebird version? As you describe it, it sounds like a bug.

Mark
--
Mark Rotteveel