Using sql server 2005.
I am querying using an alias like below:
SELECT LEFT([fieldName], 5) AS [MyAlias]
WHERE MyAlias = 'MyUserName')
so I am trying to use my alias in there "WHERE" part of my query but I keep getting an error:
"Invalid column Name "MyAlias" "
how do I use an alias in the "where" clause?
the reason I want to use alias is this:
View Complete Post