title: SQL Conversion failed when converting the varchar value to data type int
body: <p>I have this query:</p>
  
  <pre><code>SELECT C.CustomerID, 
         Q.Question_ID, 
         Q.Department,  
         C.DueDate  
  FROM homefront.dbo.TPM_Questions_Default AS Q  
  LEFT OUTER JOIN homefront.dbo.CustomerQuestions AS C 
      ON Q.Question_ID = C.QuestionID 
  INNER JOIN tblCustomers T 
      ON CONVERT(INT, CONVERT(VARCHAR(MAX), T.Customer_No )) = C.CustomerID 
  WHERE C.DueDate &lt;= GETDATE() AND C.DateCompleted IS NOT NULL
  </code></pre>
  
  <p>I just added in the <code>INNER JOIN tblCustomers T ON CONVERT(INT, CONVERT(VARCHAR(MAX), T.Customer_No )) = C.CustomerID</code></p>
  
  <p>Now I get this error:</p>
  
  <pre><code>Conversion failed when converting the varchar value 'C000432' to data type int.
  </code></pre>