Title

Searching on Field not working

Post

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?

When specifying search criteria in a text field in which email addresses are stored, the @ is often the source of trouble. In find criteria, this character is treated as a special wild card find operator instead of the actual character @.

Thus, you may need to enclose your criteria in quotes to get the correct results.

Ah, I've been doing this way too long to not have noticed that. In my other scripted searches I am substituting "\@" and didn't do it on a new search I set up. Quotations around the whole address also works fine. ID10T error on my part. Thanks for the help.