Encrypting a Column in SQL Server

Encrypt data so that even if somebody was able to reach to data it is not discernible by a simple query.