Loading lesson path
Concept visual
Start at both ends
Search for "t" in string "Customer", and return position:
SELECT InStr("Customer", "t") AS MatchPosition;The InStr() function gets the position of the first occurrence of a string in another.
Formula
This function performs a case - insensitive search.start, string1, string2, compare )
Optional. The start position for the search. Position 1 is default string1 Required. The string to be searched string2 Required. The string to search for 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 string1 is zero - length, this function returns 0
If string1 is null, this function returns null
If string2 is zero - length, this function returns the value in the start parameter
If start is > than the length of string2, this function returns 0❮ MS Access Functions