Show all Hide all


This function is used to find the number of non-overlapping occurrences of a substring withing a larger body of text.

Type: Scalar function
Area of use: General use

Return value: int

The number of non-overlapping occurrences found.


@Text mandatory nvarchar(max)
The larger body of text.
@Substring mandatory nvarchar(max)
The substring to find in the larger body of text.