<pre>LIKE concat('%',???,'%')</pre>
[[Image:Reps27.png]]{| border="1" cellpadding="5"|+!Field!!Criteria!!Meaning|+|Last Name||Like '%son'||Last names ending in the string "son"|+|Last Name||Not Like '%son'||All last names, '''except''' those ending in the string "son"|+|Title||Like 'VP%'||Titles beginning with the string "VP"|+|Title||='President'||Titles exactly matching the word "President"|+|City||Like 'N_w%'||Will return "New York", but not "Norwalk"|}
{{PrevNextStart}} [[Setting Text Criteria – Logical Operators in a Report]]
{{PrevNextMid}} [[Using Sounds Like Criteria in Reports]]{{PrevNextEnd}}
[[Category:Reports]][[Category:Criteria]]
