Re: Replace string, help!

From: Johannes Wahl <johannes.wahl_at_gnc.at>
Date: Fri, 16 Feb 2001 09:21:26 +0000
Message-ID: <3A8CF116.A06FDFDB_at_gnc.at>


why don't you use

REPLACE('MY CAR (VIENNA)','MY CAR','MY OLD CAR') ?

Willybee schrieb:

> Hi!
>
> Thanks, I use 'replace' but I have another problem with this strings.
>
> Original:
> MY CAR (DUBLIN)
> MY CAR (VIENNA)
> MY CAR (SPAIN)
>
> Replace String (result)
> MY OLD CAR (DUBLIN)
> MY OLD CAR (VIENNA)
> MY OLD CAR (SPAIN)
>
> Only I can replace any words of the string, but when I use 'replace'
> command:
>
> REPLACE ('MY CAR ','MY CAR ','MY OLD CAR ');
>
> Result:
> MY OLD CAR
> MY OLD CAR
> MY OLD CAR
>
> But... The another string??? (DUBLIN) (VIENNA) (SPAIN) ???
>
> Thx....
Received on Fri Feb 16 2001 - 10:21:26 CET

Original text of this message