all groups > sql server new users > february 2006 >
You're in the

sql server new users

group:

remove html function



remove html function Daves
2/24/2006 4:59:53 PM
sql server new users: (on Yukon) - is there an easy way to remove html tags from nvarchar(max)
field?

Re: remove html function David Portas
2/25/2006 6:45:08 PM
[quoted text, click to view]

How about before it gets into the database?

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Re: remove html function Daves
2/25/2006 8:49:43 PM
nope, I'm using html text for iteration on front page and since I use only
the first 300 characters I need to have a plain text string. I found a
function which does this actually - don't remember the url though but found
it quickly on google

[quoted text, click to view]

AddThis Social Bookmark Button