Determines if a text string or expression contains another text string or expression.
Syntax 1
|
|
Determines if a text string or expression contains another text string or expression. |
|
|
Contains(string, searchValue) |
|
|
Arguments: |
|
|
|
string |
String - A string. |
|
|
|
searchValue |
String - A string. |
Syntax 2
|
|
Determines if a text string or expression contains another text string or expression. |
|
|
Contains(string, searchValue, caseSensitive) |
|
|
Arguments: |
|
|
|
string |
String - A string. |
|
|
|
searchValue |
String - A string. |
|
|
|
caseSensitive |
Boolean - True for a case-sensitive search. If omitted, false (case-insensitive search) is used. |
Remarks
- Example: Contains("Ship to Wyoming", "Illinois") returns false.
- Example: Contains("Ship to Illinois", "Illinois") returns true.
- Example: Contains("Ship to Illinois", "illinois") returns true.
- Example: Contains("Ship to Illinois", "illinois", true) returns false.
Comments
0 comments
Article is closed for comments.