Edit

Share via

CharIndex function (Access custom web app)

  • Article

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.