Wildcard Characters

$image\ebd_ebd29.jpg$

If you want to find records with values that you only know part of or that start with a specific letter or match a certain pattern, you can use wildcard characters. The wildcards are entered in the value edit box in the filter dialog box. However you can't use wildcards in date values.

You can use the following wildcard characters in combination with the like operator.

$image\redline_long.jpg$

Wildcard Character	Matches	Examples
*	Can be used anywhere in the search string and matches any number of characters	A-30* finds A-301, A-302, A-303 02 finds A-302, D-002.1
#	Any single numeric character	A-#03 finds A-003, A-203, A-303
?	Any single alphabetic character	Buil?ing Sections finds Building Sections
[ ]	Any single character within the brackets	[DE]-* finds D-002.1 and not all the A-numbers
!	Any character not in the brackets	[!DE]-* finds all the A-numbers but not the D
-	Any one of a range of characters. The range must be in ascending order (A-Z)	[A-D]-* finds all numbers in sorted range

$image\redline_long.jpg$

Note

The special characters left bracket ([), question mark (?), number sign (#), and asterisk (*) can be used to match themselves directly only by enclosing them in brackets. The right bracket (]) can't be used within a group to match itself, but it can be used outside a group as an individual character.