By George, Jeff, I think that may be it!

Billy's answer was right - you can't use aliased columns elsewhere in a SQL expression. You have to type out the formula...

Thanks for that Jeff.

You're right as far as the example goes, but the problem comes of course when the '1' changes to a field as in :

select qty+1 as two,...

Thanks Billy, it helps to have a name for the problem "column aliasing within an expression"!

Sometimes repeating the (1+1) formula is possible, but it quickly gets unweildy.

I was...