Re: [sqlite] Formating SUM?

On 3/21/08, Gilles Ganault <[EMAIL PROTECTED]> wrote: > Hello > > I searched on the web site and "The definitive guide to SQLite", but > didn't find if it's possible to format the output from the SUM() > function: > > SELECT SUM(invoice_amount) AS Amount FROM invoice"; > > => With invoice_amou

[sqlite] Formating SUM?

Hello I searched on the web site and "The definitive guide to SQLite", but didn't find if it's possible to format the output from the SUM() function: SELECT SUM(invoice_amount) AS Amount FROM invoice"; => With invoice_amount defined as TEXT, I'd like this number to be formatted as "100.000,00',