Greetings!
select 7,915 - 5,021;
displays this result:
7|910|21
I was really looking to have 2,894 returned, but instead I received the
above. Then, I added quotes,
sqlite> select "7,915" - "5,021";
2
sqlite> select '7,915' - '5,021';
2
I was able to figure out that comma's are more important than just a 1000
number delemeter, so I received the right answer by taking the commas out:
sqlite> select 7915 - 5021;
2894
But, would someone explain the result of 2? Sorry for this child-like
question, but I can't find the how the result of 2 came to be displayed.
Thanks.
josé
Any thoughts?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
