title: Convert numeric (contains special characters) to money
body: <p>Given</p>
  
  <pre><code>declare @text varchar(4) ='3677.98*' , @text2 varchar(4) ='1245367.98%'
  </code></pre>
  
  <p>I want the output as follows:</p>
  
  <p><strong>3,677.98* and 1,245,367.98%</strong></p>
  
  <p>I tried below:</p>
  
  <pre><code>select convert(varchar,cast(3677.98 as money),1) --output as 3,677.98
  </code></pre>
  
  <p>If I try <code>select convert(varchar,cast(3677.98* as money),1)</code> it gives the error Incorrect syntax near the keyword 'as'.</p>