CharIndex function (Access custom web app)
Searches a text expression for another text expression and returns its starting position if found.
Important
Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.
Syntax
CharIndex (TextExpression, WithinText, [Start])
| Argument Name | Required | Description |
|---|---|---|
| TextExpression |
Yes |
A text expression that contains the text to be found. |
| WithinText |
Yes |
The text expression to be searched. |
| Start |
No |
An integer that specifies the location in WithinText to begin the search. If Start is not specified, is a negative number, or is 0, the search starts at the beginning of WithinText. |
Remarks
If either TextExpression or WithinText is NULL, CharIndex returns NULL.
If TextExpression is not found within WithinText, CharIndex returns 0.
The starting position returned is 1-based, not 0-based.