title: Implicit conversion from datatype 'INT' to 'VARCHAR' is not allowed
body: <p>I am trying to insert data into a table and getting </p>
  
  <blockquote>
    <p>implicit conversion error. </p>
  </blockquote>
  
  <p>Can someone please help with the syntax?</p>
  
  <pre><code>CREATE TABLE A
  (
  Column1 varchar(30) NOT NULL
  Column2 Char(12) NOT NULL
  )
  
  Insert Into A (Column1 ,Column2 )
  VALUES ('TX ID',convert(char(12), -700))
  </code></pre>