>Thanks Naomi and Sergey,
>
>I ended up using
>
>convert(char(12),convert(money,numericfield),1) as cnumericfield
>
>which has the same effect as
>
>transform(numericfield,'9,999,999.99') as cnumericfield
You're welcome, glad you have your problem solved.
If it's not broken, fix it until it is.
My Blog 
