returns the number of coinciding positions of a sub string in a stringSyntax
| 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