Behavior Changes for Range Finds after V5.5 files converted to FMPro 9
Description of the issue
I recently converted all my FMPro5.5 files to V9. A user just reported a problem with the range find using "..." in the V9 files. In FMPro5.5, the range find results would include the begin and the end points. However, after the files were converted to FMPro9, in the existing fields, the range find results would include the begin point but exclude the end point. For instance, in a text field, when search for "08...12", the results return 08,09,11 but 12 is excluded. At first, I though this was how FMPro 9 handled range find. Then I noticed in any new fields I created after the files were converted to V9, the range find would work like it's in V5, both the begin and the end points are inclusive! For testing purpose, I created a new file in FMPro 9 with a text field, the range find results in this test file included the begin and end points too. My questions is how do I fix the range find problem in the existing fields of the converted files? It's impossible for me to recreate these files in FMPro 9 from scratch within a short time. Any advice would be greatly appreciated!