Examples of using wildcards in filters:
| Pattern String |
Criterion Processed |
Sample Return Value |
| ‘Sha%’ |
Character String can be any length but must begin with “Sha” |
Shannon, Sharon, Shawn |
| ‘%son’ |
Character string can be any length but must end with “son” |
Benson, Johnson, Morrison |
| ‘%han%’ |
Character string can be any length but must contain “han” |
Buchanan, handel, Johansen, Nathanson |
| ‘Ro_’ |
Character string can be only three characters in length and must have “Ro” as the second and third letters |
Rob, Ron, Roy |
| ‘_im’ |
Character string can only be three characters in length and must have “im” as the second and third letters |
Jim, Kim, Tim |
| ‘_ar_’ |
Character string can be only four characters in length and must have “ar” as the second and third letters |
Bart, Gary, Mark |
| ‘_at%’ |
Character string can be any length but must have “at” as the second and third letters |
Gates, Matthews, Patterson |
| ‘%ac_’ |
Character string can be any length but must have “ac” as the second and third letters from the end of the string |
Apodaca, Tracy, Wallace |
*Source: SQL Query for Mere Mortals, Viescas and Hernandez, Addison Wesley (2008)