Getting error" XML parsing: line 22, character 39, undeclared prefix"

Basically i have a table in SQL with descrption column in HTML

I need to extract just the text from this column either in SQL or Power Query

One of the HTML descriptions

<p class="MsoNormal"> TEXT IN BETWEEN <span style="mso-spacerun:yes"> </span><span style="mso-spacerun:yes"> </span><o:p></o:p></p><!-- RICH TEXT -->

Can someone please help?

Hi ASI80486 ,

What kind of operation would you get this error? Please clarify your question detaily.

I found the similar posts, hope they can help you:

SQL Server XML DML Undeclared prefix - Stack Overflow

SQL Server Xml query with undeclared prefix - Stack Overflow

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.