Query on new field

[simma]

Hello
How do I query on new field we create in query.
something like
select a.a1,a.a2,(a.a3+a.a4)as 'newfield'
where newfield ='10'
Thanks

 

[amorous]

Try something like this:

select a.a1,a.a2,(a.a3+a.a4)as 'newfield'
where ( (a.a3+a.a4) =10)

-VJ

 

[nigelrivett]

or
select * from
(select a.a1,a.a2,(a.a3+a.a4)as newfield) a
where newfield =10


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[simma]

Thanks nigelrivett,Thats what I want..
Thanks Amorous,I wanted to avoid reusing the formula in where statement