R
RoadKill
This is a stupid question, but I just can't seem to remember how to do it. I
want to combine the two fields of 'FirstName' & 'LastName' in one field named
'EmployeeName'. When I do it, it doesn't put a space in the name so it looks
like 'JohnDoe'. How do I get the space in between John and Doe? My sql is
below:
SELECT [FirstName]+[Las Name] AS EmployeeName
FROM [EMPLOYEEINFO];
want to combine the two fields of 'FirstName' & 'LastName' in one field named
'EmployeeName'. When I do it, it doesn't put a space in the name so it looks
like 'JohnDoe'. How do I get the space in between John and Doe? My sql is
below:
SELECT [FirstName]+[Las Name] AS EmployeeName
FROM [EMPLOYEEINFO];