I have a password column in one of my tables.

The column is populated through the Front End.

I need to have a trigger on that column, which is going to encrypt the password while storing and another trigger which which will decrypt the password while selecting.


Can anybody give me an idea of how to accomplish this.


Thanks

Amit