title: SQL Casting Assistance
body: <pre><code>INSERT INTO PRODUCTDIM (PROD_SKU, PROD_DESCRIPTION, PROD_TYPE, LGPRODUCT.BRAND_ID, BRAND_NAME, BRAND_TYPE)
      SELECT PROD_SKU, PROD_DESCRIPT, PROD_TYPE, lgproduct.BRAND_ID, BRAND_NAME, BRAND_TYPE
      FROM LGPRODUCT INNER JOIN LGBRAND ON lgproduct.brand_id = lgbrand.brand_id
  </code></pre>
  
  <p>I am getting this error:</p>
  
  <p>Conversion failed when converting the varchar value '1010-MIW' to data type int.</p>
  
  <p>Need help</p>