Using 'Like xxx' as criteria in a query

  • Thread starter Thread starter Artie
  • Start date Start date
A

Artie

I need help returning records that either begin with a
certain text string or exclude records that begin with a
certain text string.

I have a query with 30,000 records. Our company appears
as one of the records. I want to exlude all records that
have 'Ren' in a certain field.

Thanks for any help!
 
Like "Ren*"

Above will return all records that have a value beginning with Ren.



Not Like "Ren*"

Above will return all records that don't have a value beginning with Ren.
 
Back
Top