http://forums.blackbaud.com/search/SearchResults.aspx?o=DateDescending&tag=encrypt&orTags=0Search results matching tag 'encrypt'en-USCommunityServer 2007 SP2 (Debug Build: 20611.960)http://forums.blackbaud.com/forums/p/10329/37567.aspx#37567Sun, 19 Oct 2008 16:58:38 GMTf90a95a0-00e2-4810-8af8-0bbdde08f853:3756751CA828C-2740-4A43-8ABA-E04CEF1FE4D2<p>Hi,</p> <p>I&#39;m looking for a way to find contstituents by their bank account.</p> <p>As off version 7.81 the account numbers are encrypted in the DB. <br />Using the standard CustomWhereClause doesn&#39;t work because it queries the raw (encrypted) data.</p> <p>Is there a way to encrypt the plain text (account no) and pass that in the customwhereclause ?<br />Or another filter object&nbsp;where I can give the account no in plain text as a parameter that returns a constituent collection ?</p> <p>Eric</p>