Specifications

Pos

724 InfoMaker

Pos

Description Finds one string within another string.

Syntax Pos ( string1, string2 {, start } )

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)