SQL Operators: The Square Brackets

	SQL Operators: The Square Brackets

Introduction

The left square bracket "[" and the right square bracket "]" are used to delimit the name of an object in a SQL statement.

Examples

Here is an example:

SELECT * FROM [Employees];

Here is another example:

SELECT [Employees].[FirstName], [Employees].[LastName]
FROM [Employees];

Here is another example:

SELECT DateHired AS [EmployedSince], LastName, HourlySalary AS [Pay Rate]
FROM Employees;