Description
Finds one string within another string.
Syntax
Pos ( string1, string2 {, start } )
|
Argument |
Description |
|---|---|
|
string1 |
The string in which you want to find string2. |
|
string2 |
The string you want to find in string1. |
|
start (optional) |
A long indicating where the search will begin in string. The default is 1. |
Return value
Long. Returns a long whose value is the starting position of the first occurrence of string2 in string1 after the position specified in start. If string2 is not found in string1 or if start is not within string1, Pos returns 0.
Usage
The Pos function is case sensitive.
Examples
This expression returns the position of the letter a in the value of the last_name column:
Pos(last_name, "a")
This expression returns 6:
Pos("BABE RUTH", "RU")This expression returns 1:
Pos("BABE RUTH", "B")This expression returns 0 (because the case does not match):
Pos("BABE RUTH", "be")This expression returns 0 (because it starts searching at position 5, after the occurrence of BE):
Pos("BABE RUTH", "BE", 5)See also
