title: Using Wildcard For Range of Characters In T-SQL
body: <p>I'm currently using <code>REPLACE</code> to replace the following characters below which may be found in a customers name. However, it's pretty tedious doing it this way.</p>
  
  <p>Would anyone know if there's a way to do this using a list format for example, a wildcard like such: <code>LIKE ['.',',']</code> rather than writing replace each time?</p>
  
  <pre><code>REPLACE(REPLACE(REPLACE(REPLACE(dname,'.',''),'`',''),'''',''),'  ',' ')))
  </code></pre>