Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Need help on SQL
Hallo Eric!
Look for POS.
Stefan.
Eric Pearson <eric.pearson_at_ssss.gouv.qc.ca> schrieb in im Newsbeitrag:
4vyH6.52$k95.20033_at_news20.bellglobal.com...
> Hi, i have a field names nom_concat, in it I store the name of employes in
> this format: Pearson, Eric
> it's varchar2(32)
>
> I would like to easily separate the first and last name so I can put them
in
> two different field named first_name and last_name (both are varchar2(15))
>
> I tried with LTRIM and RTRIM but it doesn't work the way I would like it
to.
> Is there an SQL function that takes all the characters in a string until
it
> meets a character that I give it i.e. a comma
>
> thanks
>
> Eric Pearson
> eric.pearson_at_ssss.gouv.qc.ca
>
>
Received on Tue May 01 2001 - 08:26:10 CDT