Like Operator
From Alchemex 7.1
Home >
Like Operator
The Like Operator is used in Filters and Parameters for doing pattern matching. Combinations of literal characters and wildcard characters can be used to locate patterns. The two wildcard characters that are supported by most Data Access Drivers are the _ (underscore) wildcard; which means any single character, and the % (percent) wildcard; which means any zero or more characters. For example the pattern _a_b% would match any words that have an 'a' as the second character and a 'b' as the fourth character.
Additional symbols for pattern matching are supported by some Data Access Drivers. These may include:
| Symbol(s) | Meaning | Example |
|---|---|---|
| [ ] | Any single character within the specified range ([a-f]) or set ([abcdef]) | '[A-J]%' is requesting words having the first letter between A and J |
| # | Any single numeric character | 'A#%' is requesting words beginning with an A and having a numeric in the second position |
| [^] | Any character not within the specified range ([^a-f]) or set ([^abcdef]) | 'S[^l]%' is requesting words beginning with S and not having a 1 in the second position |