MySQL, I'd have expected all three of the following to give the same result, but even if there's a type-conversion problem from INT, then I certainly wouldn't expect it to be different for 798.1 and 1e30 for example...
mysql> select 798 between 75.2 and 999.1; +----------------------------+ | 798 between 75.2 and 999.1 | +----------------------------+ | 1 | +----------------------------+ 1 row in set (0.01 sec) mysql> select 798 between 75.2 and 1e30; +---------------------------+ | 798 between 75.2 and 1e30 | +---------------------------+ | 0 | <<<-------- Really? +---------------------------+ 1 row in set (0.00 sec) mysql> select 798.1 between 75.2 and 1e30; +-----------------------------+ | 798.1 between 75.2 and 1e30 | +-----------------------------+ | 1 | +-----------------------------+ 1 row in set (0.00 sec) Any comments? -- Best regards, James. --------------------------------------------------------------------- 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
