Counting the number of occurrences of one string inside another in SQL

CREATE FUNCTION [dbo].[com_CountString](@Input nVarChar(max), @SearchString nVarChar(1000))RETURNS INTBEGIN if @Input is null or @SearchString is null return 0 DECLARE @InputLength INT, @SearchLength INT SELECT...