Supposing im creating a personnel database and want to store national insurance numbers etc , i want this to be encrypted in the table., But throught the client application front end , a personnel details administrator should be able to see the unencrypted data .. how would i do this ?

Santosh Benjamin