rabbi08

 Profile Answers by rabbi08 

• Jun 6th, 2008

 

select firstname||' '||secondname||' '||thirdname from tablename;

Here "||" is the concatenation operatot so names and space is concatenated.

vmdsr

 Profile Answers by vmdsr 

• Jun 10th, 2008

 

A simple select of first name, second name, third name should display in that order since some of the rows have second and third name as null.

amulmuthu

 Profile Answers by amulmuthu 

• Jun 11th, 2008

 

SELECT firstname,secondname,thirdname from the tablename

seemu123

 Profile Answers by seemu123 Questions by seemu123

• Jul 1st, 2008

 

You can find it by

select  'Names'+'  '+firstname+'  '+secondname+'  '+thirdname from tablename ...

sivagarlapati

 Profile Answers by sivagarlapati Questions by sivagarlapati

• Jul 2nd, 2009

 

select top 3 names from tablename

Try this u'll definately get the answer

godsrikanth

 Profile Answers by godsrikanth 

• Dec 3rd, 2009

 

SELECT SUBSTR('first second third',0,INSTR('first second third',' ', 1, 1))
FROM dual;
output: 'first         '


SELECT SUBSTR('first second third',
              INSTR('first second third',' ', 1, 1)+1,
              INSTR('first second third',' ',1,2)-INSTR('first second third',' ',1,1)-1)
FROM dual;
output: ' Second'

SELECT SUBSTR('first second third',
              INSTR('first second third',' ', 1, 2)+1,
              INSTR('first second third',' ',1,2)-INSTR('first second third',' ',1,1)-1)
FROM dual;
Output:'third     '

Combine above 3 queries into a select statement as follows to get desired output of 3 names in 3 seperate columns
Select substr query1, substr query2, substr query3 from dual;

Thanks
Neo

Shaik Kareem

 Profile Answers by Shaik Kareem 

• Jun 6th, 2011

 

Do u have first name,last name, third name columns in ur table
write the like this
select firstname,lastname,thirdname from emp;

farhanbaig

 Profile Answers by farhanbaig 

• Jun 6th, 2011

 

I am guessing you are looking for initcap function which are as follows:

select initcap(first_name||' '||second_name||' '||third_name) from employees;

skcwebworld

 Profile Answers by skcwebworld 

• Aug 7th, 2015

 

Code
DECLARE @Name NVARCHAR(MAX), @FName NVARCHAR(MAX), @MName NVARCHAR(MAX), @LName NVARCHAR(MAX)


SELECT @Name = SAURABH KANT CHAKRAVARTI


--select @Name = SAURABH KANT


 


 


 


SELECT @FName=SUBSTRING (@Name, 1, (PATINDEX (% %, RTRIM (LTRIM(@Name) ))))


SET        @Name = SUBSTRING (@Name, LEN(@FName)+1, LEN (@Name) - LEN(@FName))


SELECT @MName = SUBSTRING (@Name, 1 , (PATINDEX (% %, RTRIM (LTRIM(@Name) ))))


SELECT @LName = LTRIM (RTRIM (SUBSTRING (@Name, LEN(@MName)+1, LEN (@Name) - LEN(@MName))))


 


SELECT @FName AS Fname


SELECT @MName AS Mname


SELECT @LName AS Lname