[Tutor] Want to keep to two decimal places for currency

Jerry Hill malaclypse2 at gmail.com
Thu Oct 24 22:18:10 CEST 2013


On Thu, Oct 24, 2013 at 2:25 PM, bob gailer <bgailer at gmail.com> wrote:
> That;s odd - since ZIP codes are character, not integer,

It's not that odd.  US Zip codes are a sequence of digits.  I've
worked with plenty of databases where ZIP codes are held in Numeric
columns.  It's not the ideal format for ZIP codes, because it's
perfectly valid for ZIP codes to start with a 0, and Canadian zip
codes have letters in them, but I see it all the time.

-- 
Jerry


More information about the Tutor mailing list