Re: [sqlite] Problem with ORDER BY involving ROUND

Is there any reason why ROUND doesn't return a double? Because the IEEE storage format most (all?) computers use to store floating point numbers is binary based, many values that can be stored exactly in a base 10 system are rounded slightly to fit into the binary system. This is similar to the

Re: [sqlite] Problem with ORDER BY involving ROUND

> Is there any reason why ROUND doesn't return a double? Because the IEEE storage format most (all?) computers use to store floating point numbers is binary based, many values that can be stored exactly in a base 10 system are rounded slightly to fit into the binary system. This is similar to

[sqlite] Problem with ORDER BY involving ROUND

I received results in the wrong order when using ORDER BY on a column computed with ROUND, and am interested in knowing if anyone has encountered a similar problem. I have a solution to my problem at the bottom of this email, but am not sure it should be necessary. I appreciate all comments. Give