On 5 Feb 2002, at 15:11, Dan Nelson wrote: > I assume var1 is a float in the first case? Due to rounding > issues, the "=" operator will almost never work on fractions. > Use the primary key to select which record to delete, or use a > number range (var1 BETWEEN 1000.009 AND 1000.1001).
Matthias Hoffmann should also consider whether FLOAT is the right type. The fact that he's trying to see whether the value is exactly equal to 1000.1 suggests that it's not, since floats aren't good for storing exact values. If the column represents some sort of code, then a string type (like VARCHAR) is probably what he wants. If it's a currency amount, then an integer type stored as the smallest unit (cents, for example) will work much better. Fodder for the idiotic filter: sql,query -- Keith C. Ivey <[EMAIL PROTECTED]> Washington, DC --------------------------------------------------------------------- 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
