The @ symbol used in email addresses has a use in FileMaker that predates email. FileMaker started using this symbol as a wildcard to search for missing characters. For instance if you were looking for something that ends in ‘smith’, you could search for @smith, which would bring up silversmith and goldsmith etc. Apparently, database guys are old school and not into changing things just because the whole World Wide Web thing came along.
For example, if you were searching for the email address: email@example.com, here are four different methods to use to find the record you are looking for:
- Field Contents Match search uses the double equal sign: ==firstname.lastname@example.org
- Use a Space where the @ symbol would go: joeblow idaho.com
- Using the Literal Text search, put quotes around the email address: “email@example.com”
- Escape the @symbol like this: joeblow\@idaho.com
Thanks to Six Fried Rice blog for suggesting these different methods.