INSTR


 returns the number of coinciding positions of a sub string in a string


Syntax

INSTR([Pos%],Search$, Pattern$)

Arguments 

  • Pos% is optional and a numeric expression that sets the starting position for each search. If omitted, search begins at the first character position.
  • Search$ is required and a string expression being searched.
  • Pattern$ is required and a string expression sought in the search string.

Examples

INSTR("Qnowledge Wageningen", "Ede")

returns 0

INSTR("Qnowledge Wageningen", "Wageningen")

returns 11

INSTR(12, "Qnowledge Wageningen", "Wageningen")

returns 0

Quick links: Functions overview | Attribute overview | Constants overview | Dimensions overview


  • No labels