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

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