title: How to format number with "." as thousand separator, and "," as decimal separator?
body: <p>how to format number with "." as thousand separator, and "," as decimal separator in MySql?</p>
  
  <p>I'm using <code>Format</code> function like </p>
  
  <blockquote>
    <p>SELECT Format(myNumber,2) as myNumberFormatted FROM ...</p>
  </blockquote>
  
  <p>But return type is a number like: </p>
  
  <pre><code>1,000,000.00
  </code></pre>
  
  <p>instead i want </p>
  
  <pre><code>1.000.000,00
  </code></pre>
  
  <p>How to do in MySQL ? </p>
  
  <p>Thanks</p>