title: Msg 9420 illegal xml character, How to replace?
body: <p>I have a stored proc that reads thousands of xml files using openrowset dynamically.</p>
  
  <p>However within my xml files there are a few instances where the female symbol(♀) shows up in a specific  &lt;>. This results in a XML parsing error 9420. I was wondering how I could remove/replace/ignore the symbol when trying to read the xml file. Saving the file to UTF-8 does not work and would be inconvenient since I have thousands of files.</p>
  
  <p>Below is the code I use to read an xml file...</p>
  
  <pre><code>Declare @xml xml
  Select @xml = t
  from OPENROWSET (Bulk 'C:\path', SINGLE_BLOB) as Transactions(T)
  select @xml
  </code></pre>