Is anyone aware of a simple way of escaping imbedded single quotes in
strings within a PSQL procedure / trigger (short of writing a UDF)? I
need to receive a string parameter which then will be processed via
an "execute statement" and "execute block" combination and so any
imbedded single quotes need to be duplicated.

(version is Firebird 2.1)

I haven't been able to find anything obvious though it's not the
easiest thing to search for.

Thanks in advance

Alastair Breingan