CountMatches

CountMatches counts the number of times a substring occurs within a string.

Syntax

CountMatches(<input_string>, <search_string>)

Input_string is the source string to scan.

Search_string is the string pattern to count.

Return Type

Integer

Details

n/a

Examples

select CountMatches('xxxyyz xyz', 'xx')
from Empty();

select CountMatches('xxxyyz xyz', 'x')
from Empty();

Related Functions

Refer to various string functions.