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. |