ArcGIS Pro 3.3.2 query

Question

Hello, I created a query to compare two datasets:

MAX_BRK_RATE <> RATE_MAX

I want to select records in the Max_Brk_Rate that don't match the Rate_Max records. The result returned with records that did not match but also some records that matched.  Any idea why the matching records would show?

Thank you

Marzena

JoshuaBixby · Answer

Can you share a stripped down sample of data that exhibits the behavior?

MarzenaChojnacka · Answer

I can't change the data type in my table. Following a suggestion, I tried to apply a script, but it didn't work. Do you have any thoughts on why it didn't work or what I can try to round the field to two or three decimal places?

Eugene_Adkins · Answer

As @Robert_LeClair mentioned, it's difficult to say without seeing it, but one idea (if domains are not being used to create the records) is spaces after the entered data which would cause the appearance of a match to the eye but informationally there would be a mismatch due to the added space(s) at the end.