Re: Replace string, help!

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 - 03:21:26 CST