Re: AW: SQL multiple string replace

[Trevor Perry <trevor@xxxxxxxxxx>]

Birgitta,

That was the exact answer I needed - thanks.
And thanks Elvis.

Trevor


On 1/14/08 1:33 PM, "BirgittaHauser" <Hauser@xxxxxxxxxxxxxxx> wrote:

> 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