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?