I have a sql statement that want to combine FirstName and LastName together while a listbox retrieve from a table.
rs.open"Select ID,Join(FirstName,LastName),Sex from TblPerson "
You can concatenate with code like this:
"SELECT ID, FirstName + ' ' + LastName AS FullName, Sex FROM TblPerson"
If you are using SQL Server 2012 or higher then this will also work (based on your "access" tag, I assume you aren't):
"SELECT ID, CONCAT(FirstName, ' ', LastName) AS FullName, Sex FROM TblPerson"