|
<< Click to Display Table of Contents >> Navigation: String functions > InStr |
Description
Returns the position of the first occurrence of one string within another.
Syntax
InStr(string1, string2)
Parameters
Part |
Description |
string1 |
Required. String expression being searched. |
string2 |
Required. String expression searched for. |
Return Values
The InStr function returns the following values:
If |
InStr returns |
string2 is not found |
0 |
string2 is found within string1 |
Position at which match is found |