hi,
in sybase6 i've had a sql statement something like:
select number(*) as num,
num+1,
num*5
from tblObject

now in sybase8 it doesn't work becouse of using aliases in calculation. this
is a simple problem but i have many more usage of aliases in calculations.
it works if i change statement to:
select number(*),
number(*)+1,
number(*)*5
from tblObject

is there any other solution using aliases???