Contains Word

R

Rod

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

Thanks!
 
R

RoyVidar

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

Thanks!
Click to expand...

Use the Like operator in the where condition:

WHERE [Comments] Like "*retired*"
 
Top