Encrypt and Decrypt

  • Hello all,

    Anyone has any idea how to encrypt and decrypt credit card number .

    I tried to use XP_crypt with sql server2000.

    but it does't work.

    Please help.

    Thanks

  • Can you give us the error message and an example of how you're using it (please make sure to use dummy data)?

    K. Brian Kelley
    @kbriankelley

  • I use XP_Crypt all the time without difficulty. Of course, I have a licensed copy.

    Is your copy licensed? Consider: An unlicensed copy XP_Crypt only encodes up to 15 characters. Credit card numbers for MasterCard and Visa are 16 digits. AMEX is 15. If you are evalutating XP_Crypt, MC and Visa account numbers will not decode completely from an encoded string.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply