Hi,

I have a little problem that I can't seem to figure out the answer
to.

In a PSQL module I need to quote a string, but if there is a quote
inside of it, it will be the first (wrong * ) result shown below,
whereas I would need the second one.

* 'This isn't it'
'This isn''t it'.

Right now I am adding the quotes this way:

''''||FIELDVALUE||'''' but that of course leaves the inside non-
doubled which is wrong.

Hoping I don't have to use an UDF (would like to make it easier to
remotely install), I so far have not been able to find a non-slow way
of getting a quoted string with the quotes inside of it correctly
doubled.

Thanks in advance,
Rob