Determining Whether a Specific String Exists in a Field

Determining Whether a Specific String Exists in a Field

Post by L.A. Lawye » Thu, 11 Dec 2008 02:01:36


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

How is that done?
 
 
 

Determining Whether a Specific String Exists in a Field

Post by Douglas J. » Thu, 11 Dec 2008 02:08:53

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.

--
Doug Steele, Microsoft Access MVP
http://www.yqcomputer.com/
(no e-mails, please!)