Re: Replace string, help!

Hi!
But, the strings you want change are in a table column? If this is, you must do:

    update table set column_name=replace(column_name,'MY CAR','MY OLD CAR');

Regards,

                                                    ISA

"Willybee" <willybee_at_lycosmail.com> escribió en el mensaje news: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 - 03:11:11 CST