if there are no dollar signs, comma's, or other things that do not belong in numbers, then
UPDATE august SET transaction_amount = cast(transaction_amount, real) >-----Original Message----- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Jungle Boogie >Sent: Monday, 22 September, 2014 15:03 >To: sqlite-users@sqlite.org >Subject: Re: [sqlite] sqlite max arguments assistance > >Dear Igor, >-------------------------------------------- >From: Igor Tandetnik <i...@tandetnik.org> >Sent: Mon, 22 Sep 2014 16:34:18 -0400 >To: sqlite-users@sqlite.org >Subject: Re: [sqlite] sqlite max arguments assistance >> >> >> Just as I thought. You are storing your values as text - not as numbers >- and >> comparing them accordingly, in alphabetical order. > >Sorry, I'm not certain I know the answer to this as I don't generate the >data. >Opening the csv file in Excel, I did have to change the >transaction_amount >column from "general" to "number". I think your assumptions are correct, >though. I'll see if I can look at the values in the other database. > >I know the data is generated from a different database and a file is >created, >portalusemonthly.csv that's sent to a location where I can get it? > >Is there anything I can do post export from the other database to change >the >values correctly? > >-- >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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
