Determining Whether a Specific String Exists in a Field

  • Thread starter Thread starter L.A. Lawyer
  • Start date Start date
L

L.A. Lawyer

I want to determine whether a specific string of letters exists in a field
on the current field.

How is that done?
 
You can use LIKE for the criteria of a query:

SELECT Field1
FROM Table1
WHERE Field1 LIKE "*Lawyer*"

or you can use the InStr function.
 
Back
Top