SQL: Quickly count instances of a variable within a string.

Using SQL and want to know how many times 'http' appears in a string using about one line of code? Find out by creatively using the replace() function.

Declare @myStr varchar(1500), @countStr varchar(100) Set @myStr = 'https://www.buydrugshere.com go here! https://www.onlinemortage.com right there!' Set @countStr = 'http' Select (len(@myStr)-len(replace(@myStr,@countStr,'')))/len(@countStr) as theCount

This method is effective in any language that has a replace function.