我想在此字段自动为每个属性加个货币符号

Question

select avg(price) as 'average_price'
from titles我想在此字段自动为每个属性加个货币符号
比如 
$12.30
这个$如何加入啊?select '$' + avg(price) as 'average_price'
from titles
不行啊

Answer 1

select '$' + str(avg(price)) 'average_price'
from titles

Answer 2

select '$' + rtrim(1) 'average_price'
from titles

Answer 3

select '$' + rtirm(avg(price)) 'average_price'
from titles

Answer 4

--tryselect '$' + rtrim(avg(price)) as 'average_price'
from titles

Answer 5

select '$' + RTRIM(CAST(avg(price) AS CHAR(20))) 'average_price'
from titles