It just gives the column a name, for example:
SELECT '' AS CEC_UNIT;
can also be written as
SELECT CEC_UNIT = '';
Thanks RogierPronk! I appreciate it!
The actual term I believe is 'column alias' - and you can use that to rename an existing column name to something more appropriate for the calling application/user.