ADMIN_GetNumberOfOccurrences

 Show all Hide all

Deprecated.

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.

Parameters:

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