G Guest Jun 26, 2007 #1 How can I query [Comments] and return all of the records that contain "retired" or "Retired"? Thanks!
How can I query [Comments] and return all of the records that contain "retired" or "Retired"? Thanks!
R RoyVidar Jun 26, 2007 #3 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*"
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*"