MS Access InstrRev() 函数

在字符串"Customer"中搜索"t"（从字符串末尾开始）并返回位置：

SELECT InstrRev("Customer", "t") AS MatchPosition;

定义和用法

InstrRev() 函数从字符串末尾开始获取一个字符串在另一个字符串中第一次出现的位置。

该函数执行不区分大小写的搜索。

InstrRev( string1, string2, start, compare)

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

工作于：	从 Access 2000