SQL Server COUNTSTRING Function

Updated 2023-11-10 19:26:53.947000

Description

Use the scalar function COUNTSTRING to count the number of times a particular text occurs in another text.

Syntax

SELECT [westclintech].[wct].[COUNTSTRING] (
  <@Text, nvarchar(max),>
 ,<@SearchValue, nvarchar(max),>
 ,<@CaseSensitive, bit,>)

Arguments

@Text

is the text to be evaluated by the function. The @Text argument can be of data types that are implicitly convertible to nvarchar or ntext.

@SearchValue

is the value to search for in @Text. The @Value argument can be of data types that are implicitly convertible to nvarchar or ntext.

@CaseSensitive

declares the search as being either case sensitive or case insensitive, regardless of collation. The @CaseSenstive argument must be of data types that are implicitly convertible to bit.

Return Type

int

Remarks

COUNTSTRING does not support the use of wildcards.

COUNTSTRING supports case sensitive searches. @CaseSensitive = 1, makes the search case sensitive.

Examples

select wct.countstring(
'Finished files are the result of years of scientific study combined with the experience of years.'
,'f'
,0
);

This produces the following result.

{"columns":[{"field":"column 1","headerClass":"ag-right-aligned-header","cellClass":"ag-right-aligned-cell"}],"rows":[{"column 1":"6"}]}

select wct.countstring(
'Finished files are the result of years of scientific study combined with the experience of years.'
,'of '
,1
);