Trouble With Exact Match Operator
I'm having some difficulties with the exact match operator ("=="). I noticed trouble in one of my scripts and found that performing a find, even with ==, didn't return exactly what I was looking for.
As an example: Searching one field for the serial number MAK00002, also returns the serial number MSH00002, even using "==."
Is there something that I could be doing wrong within my database? I know it is hard to tell without seeing the whole thing. I just thought there may be a known issue, as this seems to have happened suddenly (I was not having this problem last week, and aside from adding some records, no changes to the code have occurred).
Any help is appreciated. Thanks!