Skip to Content
0
Apr 12, 2013 at 11:55 AM

Select query to get multiple fields in single field...

7821 Views

Dear Gurus,

I am looking for a select query to get multiple fields in single field...

like if I have to retrieve first name, middle name and last name in single field name...

e.g. ::

SELECT FNAME MNAME LNAME AS NAME "here fname mname lname take in name and try to get in name field..

INTO NAME

FROM YEMPMST

WHERE EMPCD = '12345'.

ENDSELECT.

NOTE: here select query is incorrect, I just wrote here to make you easier to understand what I want...

Many Thanks / Himanshu Gupta