AW: SQL multiple string replace

Hi,

Contrary to RPG's %REPLACE where only the first occurence gets replaced, the
SQL REPLACE replaces all occurrences.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"


-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Trevor Perry
Gesendet: Monday, January 14, 2008 17:17
An: Midrange Systems Technical Discussion
Betreff: SQL multiple string replace


The latest copies of Excel I have will not delimit the character fields with
double quotes. So, to prevent reason code 98, I changed all BLANK characters
with a % sign.

Now I have a DB2 file with % characters in the fields. How can I change the
% signs back to a BLANK with an SQL statement? %REPLACE works in RPG for a
single % in a field, but there could be more than one % in each field.

Alternatively, how can I delimit the character fields with double quotes?

Thanks in advance for your help?
Trevor