In VFP you can do this
Select somefield+somethingelse as mycalcfield from mytable where mycalcfield>10
in T-SQL it seems you have to do this
Select somefield+somethingelse as mycalcfield from mytable where somefield+somethingelse>10
which means you have to maintain both calcfield expressions which is a maintenance headache
Is there a way in T-SQL to use the calcfield alias in the where expression?
Brandon Harker
Sebae Data Solutions