CONTAINSSTRING function

Synopsis

This function returns whether the string specified with String2 can be found within the string specified with String1. This function is case sensitive.

Variations

CONTAINSSTRING(String, String2)

Returns whether a string (String2) can be found within another string (String1).

Details | Examples | Details and examples

Parameters

String

Specifies the string to be searched.

Supported types: String.

String2

Specifies the string for which to search. When String2 is empty, True is always returned.

Supported types: String.

Returns

Returned types: Boolean.

Examples

1.	The following example searches the string "Matrox Design Assistant" for "Matrox" and returns True. CONTAINSSTRING("Matrox Design Assistant", "Matrox")
2.	The following example searches the string "Matrox Design Assistant" for "MATROX" and returns False. CONTAINSSTRING("Matrox Design Assistant", "MATROX")
3.	The following example searches the string "Matrox Design Assistant" for "ox Des" and returns True. CONTAINSSTRING("Matrox Design Assistant", "ox Des")
4.	The following example searches the string "Matrox Design Assistant" for an empty string and returns True. CONTAINSSTRING("Matrox Design Assistant", "")