Re: field encryption


<janwright@xxxxxxxxx> wrote in message
news:1119900734.819270.260100@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Do any tools exist to selectively encrypt columns of data. For
> example, if I'm creating a personnel file and want to hide the social
> security numbers so I can email test files to someone?
>
>
If you only want to do one field, I have a routine I wrote which will
encrypt 8 characters at a time. I have used it to protect things like
passwords on shared databases. I can't give details of how it works for
obvious reasons. You can call it as a subroutine or use it as a component.
You give it the data you want encrypted or decrypted , and specifiy either
encrypt or decrypt, and it returns the data in the required form. If you are
not happy with any of the other selected solutions, mail me privately, and
specify what platform it is for.

Pete.



.