>How can I format my money field output in my select sentence?
A frontend is better place to format data than SQL Server.
You can use 3rd parameter of the CONVERT() function if you've to do that in a query
DECLARE @ammount money
SET @ammount = 12345678.9157
SELECT @ammount,
CONVERT(varchar(20),@ammount, 0),
CONVERT(varchar(20),@ammount, 1),
CONVERT(varchar(20),@ammount, 2)
--sb--
