Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calculated Field in Where Clause
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Calculated Field in Where Clause
Divers
Thread ID:
01451981
Message ID:
01451981
Vues:
321
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform