RE: Replace string, help!

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')
>
> ?