Saturday, June 20, 2009

String Handling Functions-InStr

The InStr function looks for a phrase that is embedded within the original phrase and returns the starting position of the embedded phrase. The format is

Instr (n, original phase, embedded phrase)

Where n is the position where the Instr function will begin to look for the embedded phrase.

For example

Instr(1, “Visual Basic”,” Basic”)=8




No comments: