Contains Word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I query [Comments] and return all of the records that contain
"retired" or "Retired"?

Thanks!
 
Rod said:
How can I query [Comments] and return all of the records that contain
"retired" or "Retired"?

Thanks!

Use the Like operator in the where condition:

WHERE [Comments] Like "*retired*"
 
Back
Top