title: Thousand Separator in DBGrid
body: <p>I'm using MySQL and Delphi XE4 to build an application.
  There are big numbers in Database and I used FORMAT function in my queries to apply Thousand Separator!</p>
  
  <pre><code>SELECT Field1,FORMAT((Field2 * Coef), 0) AS blabla FROM MyTable WHERE .....
  </code></pre>
  
  <p>Everything was fine but When I tried to add SUM function in FastReprot an logical error happend! </p>
  
  <p>FORMAT function returns the result as a string and SUM function concatenates strings!!!</p>
  
  <pre><code>SUM(frxDBDataset1."blabla",MasterData1)
  
  Product1| 123,500,000
  Product2| 1,455,999,100
  ________________________________
  SUM = 123,500,000-1,455,999,100
  </code></pre>
  
  <p>What is best way for showing thousand separator in DBGrid!
  I'm thinking about applying thousand separator in "OnGetText" Event. Does this method cause delay in showing data in DBGrid when recordcount>5000 ?</p>
  
  <p>Do you have any suggestions?</p>