>I believe there is a bug here. Yes, in I my own head!
We simply need to take care of integral values.
The correct rounding down at 3rd decimal places using SQLite can
be done so:
case
when cast(myValue as text) <> round(myValue) then
round(myValue - 0.0005, 3)
else
myValue
end
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
