declare @myvar varchar(20)
set @myvar = ’H—el-lo -Wo-r-l-d’
select len(@myvar) - len(replace(@myvar,’-',”))
set @myvar = ’H—el-lo -Wo-r-l-d’
select len(@myvar) - len(replace(@myvar,’-',”))
Result: 8
Home > Uncategorized > Finding number of occurrence of a character in SQL
Finding number of occurrence of a character in SQL
Leave a Reply
Trackbacks:0
- Listed below are links to weblogs that reference
- Finding number of occurrence of a character in SQL from extremeweblog.com