format in SQL Server

[razum]

I am using Ms Access database, I have a query which gets the 123,4567 from 1234567. to do so I use
select format(Price,'##,###')as Price from tbl_sald

Now I want to do the same in Sql server 2000 view where it does not accept the format function in the sql view.
please help me and solve my problem

 

[r937]

select convert(varchar,cast(Price as money),1) as Price
from tbl_sald

r937.com | rudy.ca