I'm trying to get MySQL to do the most simple thing possible and it appears to be failing.
I have a table with a column called basic_rental. It's a float (8,2). There are lots of records in the table. One of the records happens to have a basic_rental value of 197.87.
However, when I execute the query "Select * from TABLE where basic_rental<197.87" the row with the value of 197.87 is included in the results!
Can anyone please explain what's happening?
van leasing
