title: Search and Replace Byte Order Mark In Sql Server
body: <p>i have 10 table and more than 10000 record that contain <code>ï»¿</code>
  how can search <code>ï»¿</code> and replace this in DB?
  since the  <code>ï»¿</code> equal <code>0xEF,0xBB,0xBF</code> how can search this?</p>
  
  <p>i use this code</p>
  
  <pre><code> WITH foo(myvarbincolumn) AS
  (
  SELECT text from BPM_Letters
  )
  SELECT *
  FROM   foo
  WHERE  CONVERT(VARCHAR(max), myvarbincolumn) COLLATE Arabic_CI_AS
                      LIKE '%' + CONVERT(NVARCHAR(max), CHAR(0xEF)+CHAR(0xBB)+CHAR(0xBF)) + '%' 
  </code></pre>
  
  <p>I found this code in stackoverflow but it s incomplete.</p>
  
  <p><a href="https://drive.google.com/file/d/0B-NJ1J4kViZhcTRfWmxrMVBBNXM/view?usp=sharing" rel="nofollow">script of <code>BPM_Letters</code></a>
  this code not find any record!
  please help me</p>