AS

Use AS when you want to control the name of an output column. You can use AS in all columns and tables except the ihTrend table. In the ihTrend table, you can only use AS with the TimeStamp column.

Example: Set the Output Column Name

SELECT status, collectorname AS Name, collectortype, status AS 'The Status', collectordescription FROM ihcollectors