When searching a field in Filemaker, we found we do not receive all the records that contain what we are searching. For instance, if we search a field for 628 and we have a record with 111628 and a record with 628111 in that field, it will only return the record with 628111. As if it has to start with what we are searching and the what we are searching for cannot be between any characters. Can this be changed? We would like to see all records that contain even a partial of our seach regardless of what other characters are in front of it.
Thanks in advance!