SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Query returns HTML code with content ?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

abrkic
Starting Member

2 Posts

Posted - 03/21/2013 :  16:01:12  Show Profile  Reply with Quote
Hi everybody, can someone please help me with this ?

I createad a query, but when it is executed it gives me HTML code in the
Noted column ( see a picture ). I need to get rid of HTML code.

[url=http://postimg.org/image/520k7riod/full/][/url]

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 03/22/2013 :  01:33:06  Show Profile  Reply with Quote
whats the datatype of notes? where are you trying to display this?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

abrkic
Starting Member

2 Posts

Posted - 03/22/2013 :  12:09:49  Show Profile  Reply with Quote
quote:
Originally posted by visakh16

whats the datatype of notes? where are you trying to display this?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/





in sql management studio
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 03/22/2013 :  13:44:04  Show Profile  Reply with Quote
http://www.mssqltips.com/sqlservertip/2418/remove-html-tags-from-strings-using-the-sql-server-clr/

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.13 seconds. Powered By: Snitz Forums 2000