How come this SQL Statement doesn't work?
Select 'event2' as 'EVENTCOLN'
Select 'event2' as EVENTCOLN
Select 'event2' as "EVENTCOLN"
You're using a string literal as a column name.
If your ODBC driver doesn't support selecting values without a table name, select a random table and select the TOP 1:
SELECT TOP 1 'event2' AS EVENTCOLN FROM MyTable