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