> Why not just express all money values in terms of the smallest > division of > the currency? For example, for dollars, use cents, for pounds use > pennies.
Yes, and you can create views to show the amounts in decimal notation where you need to. I do this (store as integers, show sometimes as decimals) for a large product list. Tom BareFeet _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users