• I would argue that while all three compile and run, none of them is "correct." If they were correct, then so would this be, and you know it's not:

    SELECTmycolumnFROM MyTable;

    SELECTmycolumn FROM MyTable;

    SELECT mycolumnFROM MyTable;

    However, I'd leave the question alone. It was interesting to see weirdness in the parser.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning