Query syntax (2K SR1)

Topic

New Reply

I have a table that contains (among other things) two fields, FirstName and LastName. I want to query the table and return a single column that contains a string consisting of FirstName + ” ” + Lastname. Can someone tell me the SQL syntax to do this in Access 2000?

Reply | Quote

Replies

Try this!
Wish you well!

SELECT Trim([firstname] & ” ” & [lastname]) AS Name
FROM Student_Data;

Bill

Reply | Quote