Count Number of time a character occur in SQL Query?
To count the number of time a character occur in SQL Query:-
(1)Query to get number of time character "r" is used
declare @myvar varchar(20)
set @myvar = 'Crack Your Interview'
select len(@myvar) - len(replace(@myvar,'r',''))
(2)Query to get number of time more then 1 character is used
declare @myvar varchar(max), @tocount varchar(20)
set @myvar = 'Crack Your Interview Here'
set @tocount = 'er'
select (len(@myvar) - len(replace(@myvar,@tocount,''))) / LEN(@tocount)
| |