title: SQLite - Turning Integers into Currency
body: <p>I recently asked a question about turning currency (eg $20,000) into integers, but how might I go about turning the integers back into currency?</p>
  
  <p>E.g. 100000 -> 100,000. The dollar sign doesn't really matter to me, I'd just like a general idea about how to add commas where appropriate. I've read others use convert and cast</p>
  
  <blockquote>
    <p>E.g: convert(salary,cast(123456789 as money),1)</p>
  </blockquote>
  
  <p>but either they don't work in SQLite or I've been placing them wrongly. If it's bad practice to do so then it's no big deal.</p>
  
  <p>Any help is appreciated :)</p>