select CONVERT(varchar, CAST(valor_avaluo_catastral as money), 1) from dbo.solicitud_permutas

Only need convert your numeric field in money cast(numeric_atribute as money) ... then convert this result to varchar with CONVERT function with...