> MyValue := StringReplace(MyValue, CHR(39), CHR(39)+CHR(39),
> [rfReplaceAll]);
>
> Hope that helps
>
> Adam

Thanks Adam. That did the trick. The query did need to be built
dynamically. Interestingly, Martin's suggestion to use QuotedStr did
not help.

So what changed in Firebird 1.5 dialect 3 to make the difference?
EBZ