Re: Replace string, help!

Hi,

for the first 'MY CAR' you have to set your column name, variable or what else you want to change, e.g.:
select ..., REPLACE(column_name,'MY CAR','MY OLD CAR'), ... from ...

hth
Stephan

Willybee schrieb:

> 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 - 06:20:05 CST