[John Rogers]

If it is database(s) you are talking about, Oracle has field level encryption that stays encrypted until it is displayed on the users screen. As for individual files I used to use Winzip (paid version) and would do the zip and encrypt at the end of the day. That way you get compression and encryption together.