Select Sql Query from 2 column into one column

Question

 empid  empname  empDOB
  1      kiran    23-11-1987
  2      manu     25-4-1999

now i need to write 1 single query where empname and empDOB as single value

 empid Emp
  1    kiran,23-11-1987
  2    manu ,25-4-1999

i need the output like this

can anyone please tel me the syntax how to do it.

Possible duplicate of stackoverflow.com/questions/2137835/… — Máthé Endre-Botond
– Máthé Endre-Botond, Commented Feb 28, 2011 at 9:30

AdaTheDev · Accepted Answer · 2011-02-28 09:29:41Z

4

You can concatenate the values together like this:

SELECT empid, ISNULL(empname, '') + ',' + ISNULL(empDOB, '') AS emp
FROM YourTable

If empDOB is a DATETIME field, you could do this which will format the date in the format you've given:

SELECT empid, ISNULL(empname, '') + ',' + ISNULL(CONVERT(VARCHAR(10), empDOB, 105), '') AS emp
FROM YourTable

answered Feb 28, 2011 at 9:29

AdaTheDev

148k28 gold badges215 silver badges204 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1