Michael,
Check out the TRANSFORM() function
e.g.
TRANSFORM(Tquery.Calc_Gross, "@$$ 999,999,999.99")
Cheers,
Andrew
>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
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.