title: REGEXP_SUBSTR SQL Server
body: <pre><code>With T as
  ( 
  select 'Cytomegalovirus Nucleoside Analog DNA Polymerase Inhibitor [EPC],DNA Polymerase Inhibitors [MoA],Nucleoside Analog [Chemical/Ingredient],Nucleoside Analog Antiviral [EPC]' CLASS 
  FROM DUAL )
  </code></pre>
  
  <p>Need to pull strings with [EPC].</p>
  
  <p>Desired Output: </p>
  
  <pre><code>Cytomegalovirus Nucleoside Analog DNA Polymerase Inhibitor [EPC], Nucleoside Analog Antiviral [EPC]
  </code></pre>