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

Reply via email to