Re: Calculated Fields in SQL
no limitations in a standard select query in terms of returning columns (never has been as far as I know). There are limitations in group by queries because the alias (EntrantCode in your example) is not available.
However there are limitations on applying criteria or sorting which is what you may be thinking of.
In your example you can sort/apply criteria to the EntrantCode column, but not the EntrantDescription column.
A little thanks goes a long way. If you have found this post useful, please tick the thanks button