Loading lesson path
Concept visual
Start at both ends
Search for "t" in string "Customer" (start from the end of the string) and return position:
SELECT InstrRev("Customer", "t") AS
MatchPosition;The InstrRev() function gets the position of the first occurrence of a string in another, from the end of string.
Formula
This function performs a case - insensitive search.string1, string2, start, compare )
Required. The string to be searched string2 Required. The string to search for start
Formula
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.
-1: Use the setting of Option Compare 0: Binary comparison 1: Textual comparison 2: Comparison based on info in your database
If string2 is not found within string1, this function returns 0
Formula
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❮ MS Access Functions