sql语句类型转换问题？

[好好小妖]

select a.ProvincialCentreNumber,a.ProvincialCentreNumberCn,
Sum(DepositCount) as DepositCount,
Sum(Deposit) as Deposit,
(case when DepositCount>0 then Deposit/DepositCount else 0 end) as AvgDeposit
from Provincial a left join AbFund b on a.ProvincialCentreId=b.ProvincialCentreId
where date='0910'
group by a.ProvincialCentreNumber,a.ProvincialCentreNumberCn,
(case when DepositCount>0 then Deposit/DepositCount else 0 end)

如何把AvgDeposit 字段结果转成金额形式

[icelovey]

select a.ProvincialCentreNumber,a.ProvincialCentreNumberCn, 
    Sum(DepositCount) as DepositCount, 
    Sum(Deposit) as Deposit, 
    CAST((case when DepositCount>0 then Deposit/DepositCount else 0 end) AS MONEY) as AvgDeposit 
from Provincial a left join AbFund b on a.ProvincialCentreId=b.ProvincialCentreId 
where date='0910' 
group by a.ProvincialCentreNumber,a.ProvincialCentreNumberCn, 
    CAST((case when DepositCount>0 then Deposit/DepositCount else 0 end) AS MONEY)

[icelovey]

----数据类型转换函数---- 
CAST() 函数语法如下 
CAST() ( <expression> AS <data_ type>[ length ]) 
CONVERT() 函数语法如下 
CONVERT() ( <data_ type>[ length ], <expression> [, style]) 
select cast(100+99 as char) convert(varchar(12), getdate()) 

--转换金额
select cast(0.1234567 as money)

---------------------
0.1235

[dawugui]

select a.ProvincialCentreNumber,a.ProvincialCentreNumberCn, 
    Sum(DepositCount) as DepositCount, 
    Sum(Deposit) as Deposit, 
    cast((case when DepositCount>0 then Deposit/DepositCount else 0 end) as MONEY) as AvgDeposit 
from Provincial a left join AbFund b on a.ProvincialCentreId=b.ProvincialCentreId 
where date='0910' 
group by a.ProvincialCentreNumber,a.ProvincialCentreNumberCn, 
    (case when DepositCount>0 then Deposit/DepositCount else 0 end)