SQL Server 2000 does not have native encryption. You'll need to this outside of SQL Server or buy a third party product. Are you needing to store the password in order to authenticate against another system or just to validate a user through an application?
K. Brian Kelley
@kbriankelley