I'm doing an SQL statement to build a string field from a number field. I'll be returning the string to a web page, so I'd like to have it appear with commas.

I could write a function to convert the number to a string, then concatenate to add the needed commas, but I suspect someone out there has a better way.

I'm using:
STR(Tquery.Calc_Gross)
to show the value without commas

Any suggestions?

TIA