This should give you your exact requirements.  I modified it for you.

Regards,

J. McG.

CREATE TABLE #TextSearch (

 [Text] [varchar] (3000) NULL ,

 [Count] [int] NULL

)

DECLARE @String  varchar(1000),  @Len   int,   

 @MatchStr  varchar(50),  @StartIndex  int,...

Guys,

Here is a script that I wrote that will fulfill your needs,  the output is as follows:

Text                                      Count

<P>Famous for its rive...              3

John McG.

CREATE TABLE #TextSearch (

 [Text] [varchar] (3000) NULL...