Listing 2:

CREATE FUNCTION dbo.udfCountString
   (@S varchar(8000),
    @E varchar(  80))
RETURNS smallint
AS
BEGIN

DECLARE @Result smallint

DECLARE @I smallint

SET @I = DATALENGTH(@S)

SELECT @Result = COUNT(*)
  FROM udfGetSequence(1,@I) AS T
 WHERE SUBSTRING(@S,T.Number,@I) LIKE @E + '%'

RETURN (@Result)
END 