Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Need help on SQL

Re: Need help on SQL

From: Stefan Grundmann <s.grundmann_at_t-online.de>
Date: Tue, 1 May 2001 15:26:10 +0200
Message-ID: <9cmde5$teg$03$1@news.t-online.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US