>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

transform(Tquery.Calc_Gross, "999,999.99")