Credit Card Number Validation Escalar Function

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by thor the viking » Credit Card Number Validation Escalar...

Credit Card Number Validation Escalar Function

Rate Topic

Display Mode

Topic Options

Author

Message

thor_the_viking

Posted Thursday, March 18, 2010 7:30 PM

SSChasing Mays

Group: General Forum Members
Last Login: Monday, April 02, 2012 5:41 PM
Points: 645, Visits: 138

Comments posted to this topic are about the item Credit Card Number Validation Escalar Function

Post #886016

Adrian Scott

Posted Wednesday, March 24, 2010 2:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, September 17, 2012 8:37 AM
Points: 1, Visits: 25

This does make the assumption that the Credit Card number is unencrypted (If stored in the Database) and as the PCI/DSS regulations strictly forbids this, I would be very careful about the use of using any form of un-encrypted credit cards. This will cause you major headaches with PCI DSS - also in practice Credit Card encryption has to be performed to the Payment Card Industry standard (so you can't generally use your own encryption methods)

Reference: Requirements 3 and 4 of the PCI DSS version 1.2
https://www.pcisecuritystandards.org/security_standards/pci_dss.shtml

The Standards document as a PDF: https://www.pcisecuritystandards.org/security_standards/download.html?id=pci_dss_v1-2.pdf

Post #888746

sivakumar.ss

Posted Wednesday, March 24, 2010 2:42 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 14, 2010 4:54 AM
Points: 40, Visits: 45

Hi Thor,

Give some examples
Output is not coming!.....
Only 0 returns what ever the credit card no. given it returns only 0 not 1.

One more Query, Why u are asking for 16 digit no. for credit card. Ther are many cards with 12 digit no.

Try Try Try Again,
One Day u vl succeed..................

Post #888748

sdesai

Posted Wednesday, March 24, 2010 6:46 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 23, 2012 6:40 AM
Points: 7, Visits: 103

this works for everything but american express ... in any case my impression was that PCI DSS allows encrypted storage untill it is processed, once processed you must purge it asap.

Post #888893

Mike Dougherty

Posted Wednesday, March 24, 2010 7:14 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 22, 2010 8:59 AM
Points: 110, Visits: 952

I was really expecting to see a set-based approach to this formula.

Post #888933

« Prev Topic | Next Topic »

Permissions