Use the AS keyword to assign a correlation name to a column, aggregated value, or literal. Column correlation names cannot be enclosed in quotation marks and so cannot contain embedded spaces. In the statement below, the tokens Sub and Word are column correlation names.
SELECT SUBSTRING(company FROM 1 FOR 1) AS sub, Text AS word
FROM customer