Shaun wrote:
I have stored the dimensions as decimal(4,2), does this make a difference?
not a very good way to do it if you ask me but here is how to do the
calculation.
SELECT ((FLOOR(X) + ((X - FLOOR(X))/0.12)) * (FLOOR(Y) + ((Y -
FLOOR(Y))/0.12))) as SqFt.
FLOOR(X) gives you 6 from the 6.11
X - FLOOR(X) gives you the .11 part
.11/.12 gives you the appropriate fraction of a foot.to add back to X
then the same thing for Y and multiply.
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http://thewishzone.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]