Microsoft Access Database Development With VBA

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-2016, FunctionX, Inc. Home