title: SQL Server Varchar to VarBinary Conversion
body: <p>I have to insert the string "johnmelling" value into a table which has the column as<br>
  [USERPASS] varbinary NOT NULL.  </p>
  
  <p>Please could any one suggest me, what would be the best conversion to insert "johnmelling"?</p>
  
  <p>I tried to to insert as below,  </p>
  
  <pre><code>Insert into table(column1)
  Values(CONVERT(varbinary(1), 'johnmelling'))   
  </code></pre>
  
  <p>Then I got the error  </p>
  
  <p>Line 1: String or binary data would be truncated.  </p>
  
  <p>Thank You,</p>