[FX.php List] Finding match to an email address

[Ness, David]

What is the best approach for attempting to search for an email address entered on the website within  FileMaker using fx.PHP?

I currently trim, lower, and replace '@', '*', and "!" on both ends and search on those results for a match.

Not that it's likely, but this would result in both of these leading to a match.

abc at def.com == ab at cdef.com

Is there a better way that you use?


David Ness
FileMaker & Web Applications Developer

Bonded Builders Warranty Group
St. Petersburg, Florida USA
800-749-0381 x4923