Determining Whether a Specific String Exists in a Field

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to type each letter of the alphabet automatically in a specific color in Word? 0
Identifying a button on a toolbar 2
Determine if a record exists 8
Can you capture an event for ref in the code of the next event 4
How do I look though a set of records to find whether a specific value exists? 3
Non-English characters add '?'s to string variable 11
One form or the other depnding on certain criteria 4
Check if text string exists 5

Top