AnsweredAssumed Answered

Searching text fields that contain the @ symbol

Question asked by nsmith9110@gmail.com on Feb 7, 2014
Latest reply on Feb 10, 2014 by beverly

I have been creating a database that contians multiple users and a login script. My login script is based off the email address. The email entered in the email login field is stored as a variable and the script goes to a table containg every possible user in the database and performs a find in the email field based on what they entered. However, every time it runs the find it returns no records found. I have tried every type of find I can think of and finally discovered that the @ sign simlpy breaks the find. It will find all records that match the email up until the @ sign but, if entered, the @ sign causes no records to be found. Does anyone know why this is and/or if there is a work around and how to worko around it.

Outcomes