Dear Simon, -------------------------------------------- From: Simon Slavin <slav...@bigfraud.org> Sent: Mon, 22 Sep 2014 22:22:00 +0100 To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite] sqlite max arguments assistance > > > On 22 Sep 2014, at 10:02pm, Jungle Boogie <jungleboog...@gmail.com> wrote: > >> Is there anything I can do post export from the other database to change the >> values correctly? > > You need to strip the dollar signs off at some stage. > > Ideally you can do it in the CSV file before you import that into SQLite. > > Alternatively you may be able to do the import into SQLite then issue the > following command: > > UPDATE august SET transaction_amount = REPLACE(transaction_amount,'$','') > > before you do your SELECT. >
Actually, none of the fields have the dollar sign, that's my mistake. Can I tell sqlite pre or post import of the csv that the field is number or will it always take it as it? > Simon. -- inum: 883510009027723 sip: jungleboo...@sip2sip.info xmpp: jungle-boo...@jit.si _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users