MS Access InstrRev() Function

Posted by

MS Access

InstrRev()

Function

Example

Search for “t” in string “Customer” (start from the end of the string) and return position:

SELECT InstrRev(“Customer”, “t”) AS
MatchPosition;


Definition and Usage

The InstrRev() function gets the position of the first occurrence of a string in another,
from the end of string.

This function performs a case-insensitive search.

Syntax

InstrRev(

string1

,

string2

,

start

,

compare

)

Parameter Values

Parameter Description

string1
Required. The string to be searched

string2
Required. The string to search for

start
Optional. The start position for the search. Position -1 is default
(which means that it starts with the last character position)

compare
Optional. The type of string comparison.
Possible values:
-1: Use the setting of Option Compare
0: Binary comparison
1: Textual comparison
2: Comparison based on info in your database

Return Values

  • If string2 is not found within string1, this function returns 0
  • If string2 is zero-length, this function returns the value
    in the start parameter
  • If string1 is zero-length, this function returns 0
  • If string1 is null, this function returns null
  • If start is > than the length of string2, this function returns 0

Technical Details

Works in: From Access 2000