cleaning html tags.

does any one has any sql server function that passes some text and returns a string without html tags.

example:

nice day
should return nice day

or if other html tags strip them off.

thanks for your help.

-FrThis is not something that SQL Server is particularly good at.

You can probably accomplish this through instantiating the VBScript.RegExp libary and making use of a regular expression to strip out the HTML.

This article gives an example:Regular Expressions in T-SQL.

The pattern would probably be somthing like this: <[^>]*
Terri|||How about doing the same thing in c#?

Thanks
Fra