Determine How Many Times a String Is Found Inside Another String

The following function finds out how many times a string is found inside another string:

create  function fnOccurances (@string varchar(8000),@pattern varchar(4000)) returns smallint asbegin	declare @i int	declare @counter int	set @i=0	set @counter=0	while charindex(@pattern,@string,@i) != 0	begin		set @i=charindex(@pattern,@string,@i)+1		set @counter = @counter + 1	end			return @counterend
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: