2. PHPRunner General questions
  3. How to format a number with commas?
This topic is locked

How to format a number with commas?

 		6/29/2018 4:57:28 PM
PHPRunner General questions
John Rotella author

I want to format a number with commas, so it shows as 14,000 instead of 14000. This number is the result of a count query of a table. The number is Expr1001
SELECT

Finder,

Expr1001 AS [How Many?],

Expr1002 AS [Last Activity]

FROM [Results Query]
In a former website I used DataFormatString="{0:N0}"
Does anyone know to incorporate a similar format in my SQL in PHPRunner?

Thank You

John
J
 		John 7/8/2018

In MySQL use the format statement. See https://www.w3resource.com/mysql/string-functions/mysql-format-function.php for usage details...
John Rotella author 7/11/2018



In MySQL use the format statement. See https://www.w3resource.com/mysql/string-functions/mysql-format-function.php for usage details...



Thank you