Unanswered: Encryption at the database Field Level
The problem is as follows
I have SQL 2000 server.
I have a field which i need to be encrypted when it is stored in the database so that no one should be able to query on it or see it.
E.g. Credit Card #. I have one client server application which will take that credit card # and insert it into the table. I need some kind of encryption at the database level for this. Does SQL 2000 provides some kind of default encryption? I don't want any thing at the application level.