Find doesnt work on email field

[saad]

Hi,

I have a database in filemaker 8.5 which contains customer record. Email is a text field and contains customer email address but when I try to search on email field (from filemaker ->going in to find mode), it doesnt bring any result, however there are records matching the typed email address. If i remove the @ sign from email and search then it brings the matching result.

Can any one please tell me the reason for this and how i can fix this.

thanks

[Vaughan]

This has been mentioned before, abd it's confounded quite a few people.

Since the dawn of time "@" has been used as a wildcard character in searches. That's why finds in e-mail fields don't work as expected.

The solution is to tell FileMaker NOT to use @ as a wildcard: this is done by enclosing it in quotes, making it into literal text.

It's easier quoting the whole address.

"[email protected]"

[saad]

Thanks alot that solved the problem.