Format number in sql

[kalosjo]

select cast(nomecampo as decimal(10,2)) as alias from tabella