[ this mysql spam filter sucks -- including a query in one's message isn't good enough ]
[EMAIL PROTECTED] wrote: >>you could store them as 3 integers. The integral part, the numerator >>of the fraction and the denominator of the fraction - then interpret >>them at the client side. >> >> > >This would even have the benefit of making the whole thing sortable >(with approximations) ... > ># val_i := integer; val_n := numerator; val_d := denominator >SELECT id FROM table WHERE val_i + (val_n / val_d) < 10; > -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock --------------------------------------------------------------------- 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