Is it possible to use full text search on encrypted column in SQL Server 2008

I have a column, that is encrypted using symmetric key in a database. An encrypted content is just a text. I would like to query this text using full text search. Is it possible? I was thinking about using full text search filters to index a column, but didn't find any ready-to-use filter. So is it possible to develop such a filter, in particular, is it possible to access encryption key, that 开发者_Python百科is stored in a database, from filter code and decrypt the text from the column? Could you recommend any tutorial, how to start with such a development?

---

From what I understand, there is no support for encrypted indexes. You basically have two options:

1. You can index partial data in clear (without encryption) and match the partial data to the fully encrypted data.
2. Decrypt the data before searching

Although this post was for SQL Server 2005, it remains true for SQL Server 2008.