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 |
---|