All fields in ForestSafe that accept a pattern, obeys these pattern matching rules.
|
Wildcard |
Meaning |
|
* |
Any string of zero or more characters. |
|
% |
Any string of zero or more characters. |
|
_ |
Any single character. |
|
[ ] |
Any single character within the specified range (for example, [a-f]) or set (for example, [abcdef]). |
|
[^] |
Any single character not within the specified range (for example, [^a - f]) or set (for example, [^abcdef]). |
Figure 32 : ForestSafe extended pattern matching
Examples:
• Mi* searches for all strings that begin with the letters Mi (Miss).
• er* searches for all strings that end with the letters er (Ringer, Stringer).
• *en* searches for all strings that contain the letters en anywhere in the string (Bennet, Green, McBadden).
• _heryl searches for all six-letter names ending with the letters heryl (Cheryl, Sheryl).
• [CK]ars[eo]n searches for Carsen, Karsen, Carson, and Karson (Carson).
• [M-Z]inger searches for all names ending with the letters inger that begin with any single letter from M through Z (Ringer).
• M[^c]% searches for all names beginning with the letter M that do not have the letter c as the second letter (MacFeather).
(These pattern matching examples were taken from the Microsoft SQL Server 2008 Manual)
