InfoPath Dev

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"

Something like:

select "empID","fName","lName","employmentStatusCode", "fName" + ' ' + "lName" AS FullName from "dbo"."Employee" as "Employee"

You'll get an InfoPath warning that the SQL can't be represented as a tree, tell the warning box you are okay with that. You'll also get a warning about potentially unsafe queries, you can tell InfoPath that you are okay with that too....

Thank you very much.  Works great now.