A good way to encrypt database fields?

I've been asked to encrypt various db fields within the db.

Problem is that these fields need be decrypted after being read.

I'm using Django and SQL Server 2005.

Any good ideas?