Welcome! Log In Create A New Profile

Separating first and last names sql step 1

Posted by s2007

Announcements		Last Post
	SoC Curricula	09/30/2017 01:08PM
	Demarcation or scoping of examinations and assessment	02/13/2017 07:59AM
	School of Computing Short Learning Programmes	11/24/2014 08:37AM
	Unisa contact information	07/28/2011 01:28PM

Forums Messages New

s2007

Separating first and last names sql step 1
May 07, 2007 06:25PM

Registered: 17 years ago
Posts: 2
Rating: 0

With some perseverance, I figured it out

Reply Quote

Cameron

Re: Separating first and last names sql step 1
May 08, 2007 11:29PM

Registered: 18 years ago
Posts: 315
Rating: 0

SELECT patient_name,
instr(patient_name, Ã¢â‚¬Ëœ,Ã¢â‚¬â„¢) as PositionOfComma
INTO Q19StepOne
FROM Patient;

Select Patient_name,
PositionOfComma,
mid( Patient_name, 1, PositionOfComma Ã¢â‚¬â€œ 1) as
First_Name,
mid( Patient_name, PositionOfComma + 1) as
Second_Name
FROM Q19StepOne;

Not that it matters for the assignment now. It works, but is it most correct.