>Hi All,
> Is there a way in Sql 2000 that would allow me to encript the value of field on a given table? For example, I have a table call Acc_Hist and I have a field call CredNo. I want to encript CredNo field and not sure how to accomplish this.

There're no built-in encryption capabilites in SQL Server but there're some third party tools (in no particular order):

- http://netlib.com/sql-server-encryption.shtml
- http://www.appsecinc.com/products/dbencrypt/mssql/
- http://www.activecrypt.com/

You can find more using Google.