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?
 
jogosConnect With a Mentor Commented:
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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_jimbelConnect With a Mentor Commented:
>>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
All Courses

From novice to tech pro — start learning today.