This is an old revision of the document!
instr ( haystack_expr , needle_expr )
instr ( haystack_expr , needle_expr , start_expr )
instr ( haystack_expr , needle_expr , start_expr , boolean_expr)
returns positive_integer_value
Check to see if the string needle_expr is contained in the string haystack_expr. If it is, then this function will return the index of starting character of the first place where needle_expr occurs. Otherwise, this function will return 0.
You may optionally specify a starting location for the search to begin start_expr. If the start is 1 or greater the search will begin from the specified character from the start. If the start is < 0 then the search will begin from the nth character from the end. The search will ALWAYS look forward.
An optional boolean_expr may be used to specify that the search will treat upper and lower case letters the same.
String indices begin at 1.
print instr("Hello", "lo") print instr("101,222,333",",",5)
will display
4 8
0.9.6.55 | New to Version |
1.99.99.53 | start < 0 added |