title: SQL Server Replace with multiple SUBSTRING SSMS
body: <p>I would like to change multiple substrings at once for example
  '0100001000100'
  The desired output.
  ' | ABC | | | | DFG | | | HIG | |'</p>
  <pre><code>REPLACE(SUBSTRING([column],1,1),' 1 ' ,' XYZ '),SUBSTRING([column],2,1),' 1 ' ,' zzz ')....
  </code></pre>
  <p>but does not work.</p>