title: How to copy varchar column with currency value to decimal in SQL Server?
body: <p>I have a table with around 20K rows of data.  One varchar column contains currency info in the format $xxx,xxx,xxx.00.  I'd like to create an additional column that is of type decimal and copy the varchar data into it, obviously while stripping off the $ and ,'s.  </p>
  
  <p>I've played with cast and convert, mixed with trim and replace functions, but haven't been successful yet in getting this into a new column.</p>
  
  <p>Because we're doing many future calculations on the data, we want it converted once instead of having to convert it for each calculation.</p>
  
  <p>Any suggestions would be greatly appreciated!</p>
  
  <p>Thank you in advance!</p>
  
  <p>--Kent</p>