Trouble comparing database decimal value against numbers from csv

I am not sure what exactly I am doing wrong. Can someone help me please.
Sometimes I have trouble comparing Database decimal value against numbers from csv. (1.5 KB)

I am wondering why it is showing 780282.25000000000000000000 <> 780282.25

I am using Version And cant upgrade to newer version that our IT dept. manages it…


You can try using the round(x,2) function before doing the matching.

Seems like a bug, though. We’ll investigate it.


I am doing that. Just thought to report it in any case.

The bug has been fixed in v5.5.

1 Like