title: cast text to xml error illegal qualified name character
body: <p>how to fix error illegal qualified name character in this sample :</p>
  
  <pre><code> Declare @Str As nvarchar(256)
   Set @Str = N'&lt;Log "ReceiptStockHNo="2" ReceiptStockHDate="Feb  4 2" Comment="" /&gt;'
   Select Cast(@Str As xml) 
  </code></pre>
  
  <p>Error :</p>
  
  <blockquote>
    <p>Msg 9455, Level 16, State 1, Line 5<br>
    XML parsing: line 1, character 6, illegal qualified name character</p>
  </blockquote>