SQL encryption only returning first character
<p>I have the following query</p>

<pre><code>UPDATE mytable 
SET col1 = ENCRYPTBYPASSPHRASE ('Key', col2) 
FROM mytable
</code></pre>

<p>when I decrypt it using</p>

<pre><code>SELECT CONVERT(VARCHAR(20), DECRYPTBYPASSPHRASE ('Key', col1)) 
FROM mytable
</code></pre>

<p>The result returned is only the first character, for example if the field contains "Computer" the result is only "C".</p>