Previous PageNext Page

8.4.36 InStrRev Function

Returns the position of an occurrence of one string within another, from the end of string.
 

Syntax

InStrRev(string1, string2[, start[, compare]])

Arguments

string1
The string expression being searched. Required.
string2
The string expression being searched for. Required.
start
The numeric expression that sets the starting position for each search. If omitted, -1 is used, which means that the search begins at the last character position. If start contains Null, an error occurs. Optional.
compare
The numeric value indicating the kind of comparison to use when evaluating substrings. If omitted, a binary comparison is performed. See Settings section for values. Optional.

Settings

The compare argument can have the following values:
 

Constant Value Description
vbBinaryCompare
 
0
 
Perform a binary comparison.
 
vbTextCompare
 
1
 
Perform a textual comparison.
 

Return Values

InStrRev returns the following values:
 

If InStrRev returns
string1 is zero-length
 
0
 
string1 is Null
 
Null
 
string2 is zero-length
 
start
 
string2 is Null
 
Null
 
string2 is not found
 
0
 
string2 is found within string1
 
Position at which match is found
 
start > Len(string2)
 
0
 

Remarks

Note that the syntax for the InStrRev function is not the same as the syntax for the InStr function.
 

Copyright © 2000 Chili!Soft

Previous PageTop Of PageNext Page