title: Change column type without losing data
body: <p>I am working on an SQL Database, I have a column named "Price". When the database was created the column "Price" was set to <code>NVARCHAR</code> I need to change its type to <code>decimal(18, 2)</code> without losing the data in the database. This should be done by an SQL Script</p>
  
  <p>I thought of creating a new column, moving the data to it, remove the old column, and then rename the newly created column.</p>
  
  <p>Can someone help me with an example on how to do this?
  Also is there a function in SQL to Parse string to decimal?</p>
  
  <p>Thanks</p>