Occurs

CREATE FUNCTION dbo.Occurs 
(
@SearchExpression VARCHAR(255), 
@ExpressionSearch VARCHAR(4000)
)
RETURNS INT
AS
BEGIN
DECLARE @iRetVal INT
DECLARE @sSearchExp VARCHAR(255)
DECLARE @sExpSearch VARCHAR(4000)
DECLARE @iCurrentIndex INT

SET @sSearchExp = LOWER(@SearchExpression)
SET @sExpSearch = LOWER(@ExpressionSearch)
SET @iCurrentIndex = CHARINDEX(@sSearchExp, @sExpSearch)
SET @iRetVal = 0

IF @iCurrentIndex > 0 
BEGIN
SET @sExpSearch = RIGHT(@sExpSearch, LEN(@sExpSearch) - (@iCurrentIndex + LEN(@sSearchExp) - 1))
END

WHILE @iCurrentIndex > 0
BEGIN
SET @iRetVal = @iRetVal + 1 -- Increment Counter
SET @iCurrentIndex = CHARINDEX(@sSearchExp, @sExpSearch)
IF @iCurrentIndex > 0 
BEGIN
SET @sExpSearch = RIGHT(@sExpSearch, LEN(@sExpSearch) - (@iCurrentIndex + LEN(@sSearchExp) - 1))
END
END
RETURN @iRetVal  
END