i have a solution similar to the post above, this function will convert any number to ones with commas upto 1 Trillion .....

i.e 58,895158456.02 5 = 58,895,158,456. 025

You can change the precision of the decimal as you want, but u will need to make a slight modification to each of the cases. Currently the function will take any decimal 18,3.


CREATE FUNCTION DBO.SEPARATETHO USANDNUM
(
...