Renaming Illegally Named Columns

The SQL AS clause is used to provide aliases for columns or expressions. While primarily used to name calculated columns there is another important use – renaming illegally named table columns. To do this enclose the bad column name within single quotes, like this: SELECT ‘user login’ AS UserLogin. (Applies to: ColdFusion All)

Leave a Reply