Use the optional keyword AS to assign a correlation name to a column, aggregated value, or literal. In the statement below, the tokens Sub and Word are column correlation names.

SELECT SUBSTRING(company FROM 1 FOR 1) AS sub, Text word
FROM customer