Determining Whether a Specific String Exists in a Field

[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?

 

[Douglas J. Steele]

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.