i tried: select cast(rtrim(value,'%') as int) from ticket_custom where name = 'progress';
both, cast, and rtrim give an error, but maybe i'm just misspelling the statement. does this work for you? which sqlite version are you using? we have 3.2.2. rupert. On Jan 21, 8:09 pm, "Erik Andersson" <[EMAIL PROTECTED]> wrote: > Details on:http://www.sqlite.org/lang_expr.html > > Cheers / Erik > > On Jan 21, 2008 6:54 PM, Erik Andersson <[EMAIL PROTECTED]> wrote: > > > CAST(afield AS INT) > > > Cheers / Erik > > > On Jan 21, 2008 5:01 PM, rupert thurner <[EMAIL PROTECTED]> wrote: > > > > hi, > > > > is it somehow possible to sum up a custom field? i could not find a > > > sqlite function to convert the text to a number: > > > > rupert. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
