Introduction

The + operator is used to concatenate two fields in a SELECT statement. Here is an example:

SELECT Employees.DateHired,
       Employees.LastName + ", " + Employees.FirstName As FullName,
       Employees.Department
       FROM Employees;