title: How to identify and remove the SQL table rows that contains UTF 8 BOM characters
body: <p>I  recently identified that some of the rows in our DB tables contains UTF 8 BOM (Byte Order Marking) characters (ï»¿).. Is there a way to identify those rows and removing the BOM characters from those rows? We are using SQL SERVER 2012.</p>
  
  <p>Thanks in advance for your help...</p>