8,849
edits
Changes
no edit summary
7. You can also try using the following syntax in the Criteria box in the report builder.
<pre>LIKE concat('%',???,'%')</pre>
:{| border="1" cellpadding="5"
|+
|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]]
