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...
SELECT FNAME MNAME LNAME AS NAME "here fname mname lname take in name and try to get in name field..
WHERE EMPCD = '12345'.
NOTE: here select query is incorrect, I just wrote here to make you easier to understand what I want...
Many Thanks / Himanshu Gupta