title: SELECT encrypted items from a table using LIKE on an expression
body: <p>I am using the <a href="http://chinookdatabase.codeplex.com/releases/view/55681" rel="nofollow">Chinook Database</a> as a way to test a concept using encryption. I found that I could use the <code>LIKE</code> key word if I did:</p>
  
  <pre><code>SELECT pgp_sym_decrypt("Name", '22') FROM "Artist" WHERE pgp_sym_decrypt("Name", '22') LIKE '%a%';  
  </code></pre>
  
  <p>I'm currently trying to avoid having to use the second <code>pgp_sym_decrypt("Name", '22')</code> if at all possible thanks. </p>