Finding number of occurrence of a character in SQL

Filed in SQL Leave a comment

declare @myvar varchar(20)
set @myvar = ’H—el-lo -Wo-r-l-d’
select len(@myvar) - len(replace(@myvar,’-',”))
Result: 8

TOP