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: [email protected] [mailto:sqlite-users- >[email protected]] On Behalf Of Jungle Boogie >Sent: Monday, 22 September, 2014 15:03 >To: [email protected] >Subject: Re: [sqlite] sqlite max arguments assistance > >Dear Igor, >-------------------------------------------- >From: Igor Tandetnik <[email protected]> >Sent: Mon, 22 Sep 2014 16:34:18 -0400 >To: [email protected] >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: [email protected] >xmpp: [email protected] >_______________________________________________ >sqlite-users mailing list >[email protected] >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
