I am guessing a default value of NULL should do it. Bhavin. ----- Original Message ----- From: "Chris Kay" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, December 01, 2002 4:54 PM Subject: Calculation question
I have a few fields in a table that I need to calculate, yesterday I find out that they don't want it to display as 0.00 if nothing was entered into the database. I currently have the fields set to decimal(10,2) Would any1 suggest a better way to do this to not display the 0.00 if nothing was entered into a field, the fields need to calculate. Not to fuzzy if they see 1000 instead of 1000.00. Thanks in advance Mysql,query --------------------------------------------------------- Chris Kay (Systems Development) Techex Communications Website: www.techex.com.au Email: [EMAIL PROTECTED] Telephone: 1300 88 111 2 - Fax: (02) 9970 5788 --------------------------------------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php