fnXmlDecode

CREATE  function dbo.fnXmlDecode(@value nvarchar(4000))
    returns nvarchar(4000)
    as
    begin
        declare @i integer
        set @i = 128
        while (@i < 256) 
        begin
            if (@i = 162) set @i = 195
            set @value = replace(@value, '&#'+convert(varchar(3), @i)+';', char(@i)) 
            set @i = @i+1;
        end
        return @value
    end