RE: Replace string, help!

From: Willybee <willybee_at_lycosmail.com>
Date: Fri, 16 Feb 2001 08:44:39 GMT
Message-ID: <XL5j6.8730$YE4.284636_at_telenews.teleline.es>


Hi!

I don't use your solution because the database have 1.200.000 registers with thousand's of different strings:

(MADRID)
(PEPE)
(JUAN)
(VIENNA)
(PARIS)
(XXXX)
(asdklasie)

etc...

Only I need replace the first string 'MY CAR'...

Thx a lot for your message :-)

Johannes Wahl <johannes.wahl_at_gnc.at> escribió en el mensaje de noticias 3A8CF116.A06FDFDB_at_gnc.at...

> why don't you use
>
> REPLACE('MY CAR (VIENNA)','MY CAR','MY OLD CAR')
>
> ?
Received on Fri Feb 16 2001 - 09:44:39 CET

Original text of this message