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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users