I know it could be done trivially in a non-SQL environment [post-data processing, frontend, what have you], but that's not possible at the moment. Is there a way to take a
declare @number decimal(5,2)
set @number = 123.00
select cast(@number as varchar) as FormattedNumber
SELECT CAST(CAST(@number AS float) AS varchar(10))
However you may want to test this carefully with your raw data first.