For an Integer or Number field, does it make more sense to default values to NULL or 0?
When used for calculations, a column with NULL could cause a problem (eg. NULL * 2). Columns with NULL will be ignored in and SQL count, but columns with a 0 will be counted. Is this right? Are there other reasons to favor one use or the other? "NULL programmers are easy to find and once found can be fired since they are not needed." ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists