Is it possible to change the type of the column in a select?

ex:
select count(*) a
from table

the type for column a is system.decimal, I want it as a Number(9) is that possible?