title: How to safely convert NVARCHAR to MONEY
body: <p>I have an existing table with a 'price_info' column of type <code>NVARCHAR</code>. I'd like to add a new column 'price' of type <code>MONEY</code> and (where possible) convert/copy the contents of the 'price_info' column into it.</p>
  
  <p>If 'price_info' contains only numeric data, then the value can easily be converted. But of course 'price_info' can also contain data which cannot be converted to type <code>MONEY</code> in which case an error occurs.</p>
  
  <p>Is there a way to copy only the values where the conversion to <code>MONEY</code> is successful, and silently ignore all other rows (or set the 'price' column to 0 in these cases)?</p>
  
  <p>E.g. what I'd like to have is something like this (pseudo-code):</p>
  
  <pre><code>update products set price = some_conversion_function(money, price_info, 0)
  </code></pre>
  
  <p>(where 0 is the default value to be used if the conversion fails).</p>