I have an encrypted value, why wont it go into the varbinary field? <p>I just need to fix a couple of bad records. I am able to swap the month with the year and re-encrypt. But when I try and put it into the MS SQL SERVER varbinary field again it is getting truncated. What is the correct way to update the table with the new encrypted values?</p> <pre><code>Conn.Open strDSN Dim sql : sql = "Select * FROM tmpRefill WHERE CC &lt;&gt; 'NULL' AND CustId = 9944" rs.Open sql, Conn Dim custId, email, cc, newCC, upSQL Do Until rs.EOF Response.Write rs("CustId") Response.Write("&lt;br /&gt;") Response.Write rs("email") Response.Write("&lt;br /&gt;") cc = EnCrypt(rs("CC")) Response.Write cc Response.Write("&lt;br /&gt;") cc = Split(cc,"-") newCC = cc(0) &amp; "-" &amp; cc(2) &amp; "-" &amp; cc(1) &amp; "-" &amp; cc(3) Response.Write newCC Response.Write("&lt;br /&gt;") newCC = EnCrypt(newCC) Response.Write newCC Response.Write("&lt;br /&gt;") Response.Write("&lt;br /&gt;&lt;br /&gt;") rs.MoveNext Loop upSQL = "UPDATE tmpRefill SET CC = CONVERT(VARBINARY(500), '" &amp; newCC &amp; "') WHERE CustId = 9944" Conn.Execute (upSQL) </code></pre> <p>The datatype on the table column is varbinary(500) so I dont understand why I have to convert it to insert it.</p>