How do you implement encryption on SQL Server. We used to use the SQL Server ENCRYPT() function, but got bit hard by that when we tried to migrate to a different server.

>SQL Server... ;)
>
>>I want data in my tables to be encrypted when the data is stored and unencrypted when I access it to show on the screen.