Strign repeated in a row

/*How to count a string that number of times has repeated in a table rows.
 Here i just passes the values by dynamically. please lets have look as down*/

USE [Your_Database]
GO
/****** Object:  StoredProcedure [dbo].[Count_String_Repeated]    Script Date: 11/25/2016 9:36:53 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Creat procedure [dbo].[Count_String_Repeated]
(
@tblName as varchar(100),
@col_name as varchar(100),
@FindSubString as varchar(100)
)
as
begin
--DECLARE @LongSentence VARCHAR(MAX)
DECLARE @search_string VARCHAR(100)
declare @tbl as VARCHAR(max)
--SET @LongSentence = 'My Super Long String With Long Words'
SET @search_string = @FindSubString

set @tbl='SELECT '+ @col_name+',(LEN('+@col_name+') - LEN(REPLACE('+@col_name+','''+@search_string+''', ''''))) CntReplacedChars,
(LEN('+@col_name+') -LEN(REPLACE('+@col_name+','''+@search_string+''', '''')))/LEN('''+@search_string+''') CntOccuranceChars from '+ @tblName

--set @tbl='
--SELECT ' + @col_name +',(LEN('+ @col_name +') - LEN(REPLACE('+ @col_name +','+ @search_string +',''))) as CntReplacedChars,
--(LEN('+ @col_name +') - LEN(REPLACE('+ @col_name +','+ @search_string +''+')))/LEN('+ @search_string +','') as CntOccuranceChars from '+ @tblName
exec (@tbl)
--select @tbl

end