Previous Topic

Next Topic

Instr - SQL Function

Instr(String1: String, String2: String): Number

String position from start. Returns the position of the start of the first instance of String2 contained within String1. If String2 is not found in String1 or String1 is zero length, 0 is returned. If either argument is null, null is returned.

InstrRev function syntax has these named arguments:

Parameter

Description

String 1

Required. String to be searched for String 2.

String 2

Required. String to search for in String 1.

For example:

  Instr("moonbeam", "beam")

Returns: 5

See Also

SQL String Functions

Book Contents

Book Index