I want to edit the SQL to concatenate lastName and fName so it would be Doe, John. Is that possible and what is the correct syntax?
Current Query:
select "empID","fName","lName","employmentStatusCode" from "dbo"."Employee" as "Employee"