I searched the forums before asking, but did not find anything.

Here is the scenario, applicant entities have a field for storing an encrypted Social Security Number. The encryption can be handled either at the DB level (SQL Server 2005) or in LLBLGen, if that is possible, it doesn't matter. I'm looking for ideas on how this can be accomplished. The caveat, though, is that the end user will need to be able to query on SSNs and they will need to be displayed (unencrypted) in reports.

Now, I haven't had any coffee this morning, so I may be a little slow, but I've been thinking about this for a few days now and nothing is jumping out at me. Am I missing something painfully (and thus, embarassingly) obvious? Has anyone else run into this issue? (it can't be that uncommon of a request)

UPDATE: Looks like EncryptByPassPhrase() is what I need to use. and this post seems to answer my question: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=11220&HighLight=1

Regards,

todd