Re: SQL question

dennishancy_at_eaton.com wrote in <86njgi$qg5$1_at_nnrp1.deja.com>:

>select a+b+c+d "answer" from some_table;
>I want to only include those records where the sum a+b+c+d > 0.
>So I simply add the clause
>"where a+b+c+d > 0"
>But suppose I'm lazy (the column names are never as easy to type as a,
>b, c, and d). Is there some other way to refer to this equation?
>I tried using its alias (answer) in the where clause but the didn't
>work. Any suggestions?

you are REALLY lazy. use cut and paste in a cheap text editor. snort.

-- 
dave mausner