Agreeing strongly with the following.
If you want a name for you calculated column, then name it.
No defaults.

Bob

On 22 Oct 99 at 6:59, Michael L Gueterman wrote:

>   Although the idea of having a default (valid SQL-92 & ODBC) column
> name derived from functions, expressions, and constants may be nice,
> I'm not sure if that is part of the SQL standard.  Even if it is, what is
> being proposed will solve these problems with just a little extra typing
>
> SELECT MAX(SELL_PRICE) AS MAXSELL_PRICE FROM DB.INV_MASTER
>
> After waiting *SO LONG* for this enhancement, I'm extremely reluctant
> to try adding adding to the original request.  Obviously if it turns out that
> these can be added with little to no additional effort, then by all means.
> If it means delaying the addition of the "AS" clause even by one Express
> or PowerPatch (regardless of its spelling :) Release, then let's add these
> suggestions in as separate Enhancement issues on the SIG Allbase
> Ballot.
--=--=--
Bob Walker, Computer Centre  --  [log in to unmask]
Capilano College, North Vancouver, BC, CANADA.
------
'No one is listening until you make a mistake.'