InstrRev

This function determines the position of an occurrence of one string within another string, from the end of the string being searched.

Syntax

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

Parameters

string1
Required. String expression being searched.
string2
Required. String expression being searched for.
start
Optional. 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.
compare
Optional. Numeric value that indicates the kind of comparison to use when evaluating substrings. If omitted, a binary comparison is performed. The following table shows the possible values for the compare parameter.
Constant
Value
Description
vbBinaryCompare 0 Perform a binary comparison.
vbTextCompare 1 Perform a textual comparison.
vbDatabaseCompare 2 Not supported.

Return Values

The following table shows the return values for the InStrRev function.

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 InstrRev differs from the syntax for Instr.