Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 getting unnecessary data in a column

Author  Topic 

naidu4u
Starting Member

23 Posts

Posted - 2010-09-28 : 12:14:21
Am a cognos developer but when am trying to display a column from database directly its showing some unnecessary tags and my team leader told me to write the database function to get rid of that mess.

The data am getting is like this
Comment:
some useful information, </br>
again some more info </br>
again some info </br>
<span style="font-family: arial;"> some useful info </span> and so on in almost all the rows in that column.

Please help me with some function to get rid of these </br>, <span> and other messy data.

Thanks in advance.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-09-28 : 12:42:33
Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=150786
Go to Top of Page
   

- Advertisement -