SQL Operators: +

	SQL Keyword: AS

Description

The AS keyword is used in a SELECT statement to specify the caption of a field.

Examples

Here is an example that applies the AS keyword to a field:

USE Exercise;
GO

SELECT EmployeeNumber AS N'Empl #',
	   EmployeeName AS N'Full Name',
	   DateHired AS N'Employed Since',
	   HourlySalary
FROM Employees;
GO