Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculated Field in Where Clause
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Calculated Field in Where Clause
Miscellaneous
Thread ID:
01451981
Message ID:
01451981
Views:
320
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
Next
Reply
Map
View

Click here to load this message in the networking platform