title: Casting String to Money Value in SQL Server
body: <p>Is there a simple built-in way of converting NVARCHARs in the format "$1,000.00" and "($1,000.00)" to the numerical values 1000.00 and -1000.00 respectively?</p>
  
  <p>I'm trying to do this in either SQL Server or SSIS.</p>
  
  <p>Casting to MONEY gives me the error</p>
  
  <pre><code>"Cannot convert a char value to money. The char value has incorrect syntax.".
  </code></pre>
  
  <p>when attempting to cast the negative value, I'm assuming due to the parenthesis.</p>