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>
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