ArcGIS Pro 3.3.2 query

[MarzenaChojnacka]

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

[Robert_LeClair]

@MarzenaChojnacka - without knowing much about the data, it's kind of difficult to troubleshoot this error.  If possible, can you share the data with me?  My email address is rleclair at esri dot com - thanks!

[Eugene_Adkins]

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.

[MarzenaChojnacka]

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?

[JoshuaBixby]

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