8,849
edits
Changes
no edit summary
{{SeqReportPageHeader}}
A [[Wildcard|wildcard]] character is used in criteria to replace one or more unknown characters in the field. For example, if you need to display only names beginning with the letter “A”, then you would need to use a [[Wildcard|wildcard]].
* '''Like''' - the "like" operator is used to retrieve values for a field, where a comparison is made between the value specified, and the value for that field in the database. For example: '''Like 'A%''''. The percent sign - % matches any number of characters. It can be used in any position in the character string. Like ''''miss%ga''''.
* '''_''' matches a single character. It can be used in any position in the character string. Like 'N_W%’
1. Display the '''[[Report Builder]]''' window.
2. Set the '''criteria''' for the first column to be '''Like ‘A5’<nowiki>'A%'</nowiki>'''.
[[Image:Reps35.png]]
<pre>LIKE concat('%',???,'%')</pre>
{{PrevNextStart}} [[Setting Text Criteria – Logical Operators in a Report]]
{{PrevNextMid}} [[Using Sounds Like Criteria in Reports]] {{PrevNextEnd}}
[[Category:Reports]][[Category:Criteria]]
