CODE EXAMPLE FOR SQL

SQL Server - Count number of times a specific character appears in a string

declare @myvar varchar(20)
set @myvar = 'Hello World'

select len(@myvar) - len(replace(@myvar,'o',''))