MQSeries.net :: View topic

NiceGuy · Posted: Thu May 26, 2011 7:47 am Post subject:

Hi Community,

I've attempted to google and research this for a while but how can I
escape the ' (single quote character) in an ESQL node?

For example:

REPLACE(source_string, ''', '');

** please note the three single quotes, might be hard to see here.

This does not work (obviously) but neither does placing a
blackslash or forward slash in front of the single quote I wish
to escape.

Can someone help out and educate me?

Thanks and much appreciated.