Home

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;

Home Copyright © 2009-2010 FunctionX, Inc.