I have a database which is searchable by zip code and I want to also make it searchable by area code and prefix.
I have the form set up where the user can enter an area code and a prefix.
In the database one of the fields is 'Phone'.
Is it possible to select the records in the database by comparing the form input to only the first 6 digits of the 'phone' field??
Any help is appreciated.