Searching on Field not working
I have a field that holds email addresses. Recently, when I search on it, it comes up with either no results or strange results. I figured this was corrupted index. First, I compacted the file, then turned off the index and rebuilt it. It still doesn't work. I then exported the content out to a CSV file and imported it back into the field. That didn't work either. It's a very large file so I'm trying to avoid exporting everything out and back into a clone table. Does anyone else have any suggestions?
I"m using FM Adv 12.4