[dba-SQLServer] Decoding HTML in SQL Server Table

Susan Geller sgeller at cce.umn.edu
Tue Jan 25 13:43:48 CST 2005


I am trying to create a report in Access using data in SQL Server.  The
data is written to SQL Server through a c#.net application. The
application stores the data for one field encoded with html so I have
text that looks like this:

>Subject: RE: my program 
>Date: Thu, 30 Dec 2004 09:25:12 -0600 
> 
>Hi Janelle, 
> 

I want to decode the html and make it look like straight text when it
appears in my Access report.  I can't figure out how to do it either in
SQL Server or in Access.  Ideas anybody?

Thanks.

--Susan


Susan B. Geller
Office of Information Systems
College of Continuing Education
University of Minnesota
306 Wesbrook Hall
77 Pleasant Street SE
Minneapolis, MN 55455
Phone:  612-626-4785
Fax:  612-625-2568





More information about the dba-SQLServer mailing list