DBPatternMatch
Mon 01 January 2018Syntax
DBPatternMatch(Value, Pattern, CaseSensitive)
Description
Use the DBPatternMatch function to match the string in Value to the given pattern.
You can use wildcard characters % and _ when searching. % means find all characters, while _ means find a single character. For example, if you wanted to find if the string in Value started with the letter M, you'd use "M%" for Pattern . If you wanted to find either DATE or DATA, use "DAT_" for Pattern .
These characters can be escaped (that is, ignored) using a \. For example, if you want to search for a value that contains the character %, use \% in Pattern .
If Pattern is an empty string, this function retrieves the value just based on the specified case-sensitivity (that is, specifying "" for Pattern is the same as specifying "%").
Parameters
|
Field or Control |
Definition |
|---|---|
| Value |
Specify the string to be searched. |
| Pattern |
Specify the pattern to be used when searching. |
| CaseSensitive |
Specify whether the search is case-sensitive. This parameter takes a Boolean value: True, the search is case-sensitive, False, it is not. |
Returns
Returns a Boolean value. True if the string matches the pattern, False otherwise.