compare plain html text

In a table I have text that sometimes is html, for example "ö" becomes "ö"
I need to compare this with plain text. How can I do that?
johnkainnAsked:
Who is Participating?
 
jogosCommented:
I agree this is not something where T-sql is made for ... that's why I suggested to look at linked sollution and when necessary implement it as CLR
0
 
anarki_jimbelCommented:
Could you please tell more about your task?

Do you need an external tool to compare? Or you want to to do that in your code pro grammatically?
Examples?
What outcome you want from your examples?
0
 
anarki_jimbelCommented:
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
johnkainnAuthor Commented:
I was hoping to do this in sql.
0
 
jogosCommented:
>>I was hoping to do this in sql.<<

That can by making a CLR-function of the codeproject-compare with the things you need.

Pure T-sql you can use replace for all characters you think necessary .... and after gone trough the 'htmlchar-replacer' you can compare the strings.

replace(htmlString, 'ö', '&ouml;')
or the other way
replace(htmlString, '&ouml;', 'ö')
0
 
anarki_jimbelCommented:
>>I was hoping to do this in sql.<<

You may try to do as in the previous post but I believe it is not reliable way.
And it would be nice if you put your requirements upfront...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.