RE: AW: REPLACE function in SQL

[MKirkpatrick@xxxxxxxxxxxxxxxxx]

Thanks again.




"Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
09/07/2007 12:53 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: AW: REPLACE function in SQL






Just double up on it, i.e.:

SELECT   replace(translate(field,'""','%&'''),'"', '') FROM   file

Notice that following ampersand character there are double apostrophes,
representing a single apostrophe in the data of course.

Elvis

Meet us in person:
RPG & DB2 Summit | Minneapolis
2007 System i Fall Technical Conference | Orlando

-----Original Message-----
Subject: Re: AW: REPLACE function in SQL

Just one more thing.
What if I am replacing a single quote (') or want to translate a single 
quote (') to another char or blank?
Thanks.