InStr

Returns the position of the first occurrence of one string within another.

Syntax

«value» InStr ([offset,] fullStr, findStr [,caseInsensitive])

This table describes the parameters:

Parameters Description
offset Optional. Numeric expression indicating the start position for the query. If offset is not specified, the query begins with the first character of the string. If offset includes the value null, an error occurs. If caseInsensitive is specified, offset must be specified as well. The default value is offset = 0.
fullStr Required. String to be searched through.
findStr Required. String to be searched for.
caseInsensitive Optional. Specifies the type of string comparison: case-sensitive or case-insensitive. The default is: caseInsensitive = true.