Posted by T.Taylor on 01/25/06 20:56

The stop parameter is the last character's position not the length.

Example:
=======
str="hello"
Mid(str,2,4) would equal "ell"

InStr is function that returns the start position in a string where it
found the value otherwise is returns 0

Example:
========
str="hello"
value1="he"
value2 ="ll"
value3="low"

InStr(str,value1) would return 1 as the position it found the value
string starting location
InStr(str,value2) would return 3; the starting position of the value in
the string
InStr(str,value3) would return 0; because it couldn't find the value in
the string

[Back to original message]