title: MySQL Decimal format
body: <p>I have 2 TEXT columns in my table (AmountPaid and AmountRemaining). The format is € 10.000,00</p>
  <p>I am trying to create a query that pluses these 2 values, and convert it back to the format as show above (€ 10.000,00). Of course this should also work with for example € 100.000.000,00, € 690,00 or € 10,00 etc...</p>
  <p>For now I have this query witch plusses the values:</p>
  <pre><code>SELECT AmountRemaining, CAST(REPLACE(REPLACE(REPLACE(CAST(AmountRemaining AS CHAR), '€ ', '') , '.', ''), ',00', '') AS DECIMAL) + 
  CAST(REPLACE(REPLACE(REPLACE(CAST(AmountPaid AS CHAR), '€ ', '') , '.', ''), ',00', '') AS DECIMAL) FROM Clients
  </code></pre>
  <p>The output of this is like this &quot;10000&quot;, &quot;13000&quot; etc...</p>
  <p>How can I convert this back to the original format?</p>
  <p>Thanks.</p>