Tom.Thomson (9/13/2011)

---

Amusing and fairly easy question.

The misprints in the explanation may have left some people confused. All three alias forms are wrong (1st missing "= <", second and third bpth missing "alias").

edit: I can make typos too. Fixed.

Olga B (9/13/2011)

---

Ah yes, my "favorite" bit of SQL syntax

select 0 [A]

A fun bug to find when I accidentally delete a comma and then try to figure out what's wrong with the output of

select col1
       col2, 
       col1003
from sometable

What? I can't be the only one!

Thanks for the question!

select col1 AS [newcolname/sometime user friendly col name]
from sometable