""RedRed!com IT Department"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Jay Blanchard wrote: >> [snip] >> I read this as a SQL syntax question, not a math word problem. As in >> >> SELECT ..., (some expression equaling sq ft) AS sqft... >> [/snip] >> >> Cool, then do it! >> > > > It would all depend on how he has his feet and inches saved in the table, > and of course, the field names. If we can get that info then maybe we > would be better able to post a solution.
Sorry Guys, I am just storing the X and Y, so 6 foot 11 inches would be stored as 6.11 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]