calling a sclar function select query

Question

i have written one function, function name fn_parsehtml.

 

function fn_parsehtml as follows

 

CREATE FUNCTION [dbo].[fn_parsehtml]

(

@htmldesc varchar(max)

)

returns varchar(max)

as

begin

declare @first int, @last int,@len int

set @first = CHARINDEX('<',@htmldesc)

set @last = CHARINDEX('>',@htmldesc,CHARINDEX('<',@htmldesc))

set @len = (@last - @first) + 1

while @first > 0 AND @last > 0 AND @len > 0

begin

---Stuff function is used to insert string at given position and delete number of characters specified from original string

set @htmldesc = STUFF(@htmldesc,@first,@len,'')

SET @first = CHARINDEX('<',@htmldesc)

set @last = CHARINDEX('>',@htmldesc,CHARINDEX('<',@htmldesc))

set @len = (@last - @first) + 1

end

return LTRIM(RTRIM(@htmldesc))

end

 

i have one table as follows

 

Table name Sample

 

in table sample record as follows

 

Courselist

 

<table backcolor: #fffff3" width="50"> <tr> <td> fees paid by cash> </td> </tr></table>

<table backcolor: #gfr4" width="850"> <tr> <td> no amount dues> </td> </tr></table>

Select dbo.fn_parsehtml('Courselist')

 

but when i execute above query i get output as follows

 

Courselist (courselist column name only i am getting).

 

( the courselist column name only i am getting. i want courselist values as fees paid by cash and no amount dues)

 

what is the mistake in my above code.