Encryption is a good solution except that encrypted data most often takes a larger field that what has been defined for the unencrypted data. So to keep this data in the same file you are forced into defining a new field. That may work for you depending on how many logical files you have defined over this file or how many programs you have referencing this file. Another method you could consider would be to move the data that needs to be encrypted into a separate file and keep a reference to the field in the other file in the original field. This method can be less disruptive.
================================== MORE INFORMATION ON THIS TOPIC ==================================
The Best Web Links: tips, tutorials and more.
Search400's targeted search engine: Get relevant information on security.
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
Check out this Search400.com Featured Topic: Top ten security tips
This was first published in May 2004