SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by thor the viking / Credit Card Number Validation Escalar Function / Latest Posts

RE: Credit Card Number Validation Escalar Function

Mike Dougherty — Wed, 24 Mar 2010 07:14:54 GMT

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

RE: Credit Card Number Validation Escalar Function

sdesai — Wed, 24 Mar 2010 06:46:17 GMT

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.

RE: Credit Card Number Validation Escalar Function

sivakumar.ss — Wed, 24 Mar 2010 02:42:20 GMT

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.

RE: Credit Card Number Validation Escalar Function

Adrian Scott — Wed, 24 Mar 2010 02:38:53 GMT

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[url=https://www.pcisecuritystandards.org/security_standards/pci_dss.shtml]https://www.pcisecuritystandards.org/security_standards/pci_dss.shtml[/url]The Standards document as a PDF: [url=https://www.pcisecuritystandards.org/security_standards/download.html?id=pci_dss_v1-2.pdf]https://www.pcisecuritystandards.org/security_standards/download.html?id=pci_dss_v1-2.pdf[/url]

Credit Card Number Validation Escalar Function

thor_the_viking — Thu, 18 Mar 2010 19:30:28 GMT

Comments posted to this topic are about the item [B]Credit Card Number Validation Escalar Function[/B]