MQSeries.net :: View topic - difficulty replacing single quote with 2 of it

pcelari · Posted: Fri Feb 03, 2012 2:29 am Post subject:

Hello,

in calling a stored procedure, one parameter is a string. But it may contain single quote '. To excape this for the stored procedure call, I need to insert another '. So I use the replace function to do this.

content of strParm: "Bob's Saloon". - the single quote fails stored procedure call.

set strParm=replace(strParm, ''', '''');

But it results in error for the next statement.

What should I do?

thanks a lot.
_________________
pcelari
-----------------------------------------
- a master of always being a newbie