I want to Replace a special charact

[db2sachin]

I want to Replace a special character with some other character using Replace function. The character to be replaced is '. Now how do i do it ?
I tried this...
update TTM_AIR_TICKET_MST set ATC_AIR_TKT_STATUS_CD = replace(ATC_AIR_TKT_STATUS_CD,'/''{escape '/'},'O' ) ;

 

[Dagon]

update TTM_AIR_TICKET_MST set ATC_AIR_TKT_STATUS_CD = replace(ATC_AIR_TKT_STATUS_CD,'''','O' ) ;

 

[db2sachin]

That means single quotes (') itself is an escape character for db2 ?

 

[Dagon]

Effectively. Two single quotes together are interpreted as one single quote.

 

[amazingavi]

How to escape semicolon character in a select statement?

eg: select ';' from sometable

I get a execption while trying to execute the above statement.

Someone plz me with this.