[firebird-support] Re: REPLACE() Retaining EOF marker from BLOB

[red_october2009]

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()