Pos

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.

Returns

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

Example 1

This expression returns the position of the letter a in the value of the last_name column:

Pos(last_name, "a")

Example 2

This expression returns 6:

Pos("BABE RUTH", "RU")

Example 3

This expression returns 1:

Pos("BABE RUTH", "B")

Example 4

This expression returns 0 (because the case does not match):

Pos("BABE RUTH", "be")

Example 5

This expression returns 0 (because it starts searching at position 5, after the occurrence of BE):

Pos("BABE RUTH", "BE", 5)

See also