title: MS Access Partial String Query
body: <p>I am trying to run a query that will return the names that match. For example, I have one table called UserNames. In User names there are records like this: "Fields, Sally L.". In another table, called Customer, I have a column for first name with the name Sally and a column for Last Name with the name Fields. </p>
  
  <p>How can I run a query to match them? In essence, I think I need to use a like operator and or also the InStr function. But I am not sure how to actually do it. </p>
  
  <p>Any help would be appreciated.</p>