Here are some choices. Formatting in SQL Server is limited,
since it is not intended to be a report generator.
declare m money
set m = 99999
select convert(varchar(30), m, 1)
select convert(varchar(30), m, 3)
select cast(m as decimal(20,2))
>Hello All & Greetings.
>Can someone pl tell me in a hurry how I can format a currency item in 2
>thanks in advance.