Re: Need help on SQL

From: Steve Rainbird <steve.rainbird_at_mssint.com>
Date: Tue, 1 May 2001 20:28:01 +0100
Message-ID: <9cn2oa$5fo$1@neptunium.btinternet.com>

You can use instr as in

substr(nom_concat,firstname',1,instr(nom_concat,firstname',',')) and substr(nom_concat,firstname',instr(nom_concat,firstname',',') + 1)

--
Steve Rainbird
Principal consultant
MSS International Ltd.
www.mssint.com

"Eric Pearson" <eric.pearson_at_ssss.gouv.qc.ca> wrote in message
news: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 - 14:28:01 CDT