I am recommending a lengthy but good article below. It will help you narrow down the term Encryption (for database / column etc.)
Database Encryption in SQL Server 2008 Enterprise Edition
http://msdn.microsoft.com/en-us/library/cc278098(v=SQL.100).aspx