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