title: How to CONVERT/CAST a column in sql query
body: <p>can someone help with this. I'm having a problem with this sql query.
  I need to convert price1_split to int. But it seems it also gets the concatenation i made beside it.</p>
  
  <pre><code>SELECT product_number,product_name,description,
  price1+ ' ' + CONVERT(INT, price1_split) + '% |' + 
  price2+ ' ' + CONVERT(INT, price2_split) + '% |' + 
  price3+ ' ' + CONVERT(INT, price3_split) + '%'  as price_split
  from tbl_products
  </code></pre>
  
  <p>error msg says:
  Conversion failed when converting the varchar value '% |' to data type int.</p>