Re: about using expression in select

>hi all: > Is there anyway to use an expression in select statement and refer >to that expression later on in where or gropuby? > like the following: > > select col.a+col.b as exp1 from tablename > where exp1 = '199801' > groupby exp1 > > possible? select col.a+col.b exp1 from tablename group by 1 You might be able to use a HAVING clause to to fake a WHERE clause, I don't have a server handy to try it out. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com