title: How to replace specific string from column value in SQL Server
body: <p>I have <code>varchar</code> column in my table which has some data like:</p>
  
  <pre><code>"#306 loream ipsum aaabbbqqqcc"
  "#302 loream ipsum aaabbbceefec"
  "#330 loream ipsum aaabbbccsds"
  </code></pre>
  
  <p>I want to replace <code>#3XX</code> like regex syntax in C# or JavaScript.</p>
  
  <p>How to implement this in SQL Server?</p>