title: SQL convert varchar into money
body: <p>I am attempting to calculate the total cost of items and and having that value into a new column called cost.</p>
  
  <p>In my creation script the values are in characters but the data type is money. </p>
  
  <pre><code>CREATE VIEW ordered_pizzas_view
  AS 
      SELECT 
          orderpizza_id, order_id, ..., 
          CONCAT(range_price, ' ', crust_surcharge, ' ', sauce_surcharge) AS 'cost'
      FROM 
          order_pizza 
      INNER JOIN 
          ...
      WHERE 
          'cost' = (SELECT SUM(CAST(range_price AS MONEY)) FROM pizza_range) +
                   (SELECT SUM(CAST(crust_surcharge AS MONEY)) FROM crust) +
                   (SELECT SUM(CAST(Sauce_surcharge AS MONEY)) FROM sauce)
  </code></pre>