I need to search access database fields that have names and titles. I know about LIKE but I need something that would pull all records where the field contains the value that the user entered.<BR><BR>For example the field may have John Smith as an author of an article. If the user enters John they get him. But if they enter Smith they won't. <BR><BR>Wait before you say it...not my database and there are too many odd records to split the fields in any way that would be accurate.<BR><BR>Anyone know of a something that is like LIKE but would be contains instead?