Selecting records with specific strings

  • Thread starter Thread starter Gene
  • Start date Start date
G

Gene

I need to select records with specific strings within a
column. Could the POSITION function be used to find
records where the retured vlaue is > 0? If so how do you
specify the column if POSITION requires the use if IN, as
in, POSITION('X' IN 'Excel')? What I need is a test for
specific strings within the contents of entire field such
as memo fields.

Is there another SQL approach?

Thanks!
 
Try using criteria with the LIKE operator.

Field: YourMemoField
Criteria: LIKE "*XRay*"

Even more flexible

Criteria: LIKE "*" & [Enter Search Value] & "*"
 
Back
Top