See
Formatting a decimal or money with commas Message #
1244737>
>In SQL Server, Is there a way to do:
>select transform(numericfield,'9,999,999.99') as cnumericfield
>
>This would at least save me from having to do that 2 part process of select then replace.
--sb--