contains()

Syntax:

contains( String, Term, IgnoreCase )

Return:

true if the value in Term is found in String. Otherwise false.

Parameters:

String - The string to be searched. The String can be any string surrounded by quote marks or a variable name containing a string.

Term - The string to search for within String. The Term can be any string surrounded by quote marks or a variable name containing a string.

IgnoreCase – If true the comparison will ignore the case of the characters being compared; if false then the comprison is case sensitive. This parameter is optional and the default value is false.

Remarks:

Both parameters are required for this function. This function is case-sensitive, in order to return the value true, the value of Term must not only match part (or all) of the value of String, it must also be in the same upper or lower case letters.

Examples