At 09:38a -0400 08/22/2006, Bill Steele didst inscribe upon an 
electronic papyrus:

>I have several scripts that search a Filemaker 8 database for 
>someone's e-mail address.  Syntax:
[snip]
>What's fun is that it works in some scripts and not in others. It 
>turns out that "@" is a wildcard character in Filemaker searches, so 
>in some scripts I split the address and just look for the first 
>part. If I don't, the script gives me "event not handled."  But 
>another script searches for the entire address, @ and all, and it 
>finds the record anyway.
>
>In another script, by experiment I found that  "john.smith" gives an 
>error "Object not found," but "smith" finds the record (and a bunch 
>of others!" ).
>
>Suggestions?

Add a [stored] calc field?