Re: Question.

From: Javier <jmoreno_at_hag.es>
Date: Mon, 19 Feb 2001 16:31:15 GMT
Message-ID: <nTbk6.29738$3n.1285115@telenews.teleline.es>

Search help for TRANSLATE function.

TRANSLATE(<STRING>,"COMPANY","C.")

Better see documentation for exact syntax.

Hope it will be useful.

"Willybee" <willybee_at_lycosmail.com> escribió en el mensaje news:Dhbk6.29403$3n.1274331_at_telenews.teleline.es...
> Hi!
>
> How I need to do this:
>
> I have a database with this structure:
>
> NAME varchar2(100)
> STREET varchar2(36)
> CITY varchar2(40)
>
> The content of NAME is:
>
> SHOES COMPANY, S.A.
> SHOES BLUE COMP. S.A
> SHOES RED C. S.A
> SHOES & SPORT, S.L.
> CAR & CYCLES, S.A.
> CAR & MOTOR COMP. S.A.
> TRAVEL COMPANY, S.A.
>
> Ok.... the question is:
>
> The database have 1.200.000 registers. Now, I need to normalize this
> database:
>
> SHOES COMPANY SA
> SHOES BLUE COMPANY SA
> SHOES RED COMPANY SA
> SHOES & SPORT SL
> CAR & CYCLES SA
> CAR & MOTOR COMPANY SA
> TRAVEL COMPANY SA
>
> All the strings 'C.' to 'COMPANY', all the strings 'COMP.' to 'COMPANY',
> delete the characters ',' and '.'
>
> Well... How I can do it????
>
> Thaks a lot... You can save my life with this!!!!!!! :-)
>
> Kind regards....
>
>
Received on Mon Feb 19 2001 - 10:31:15 CST