Need Help Identifying Credit Card Numbers in your databases?
Do you work in a PCI environment? If you need to identify payment data within your databases this function can be used to help you do so. The function accepts a BigInt datatype representing a credit card number and will run it through a LUHN function to determine whether it is a valid credit card number.
Here is a good reference if you need to port the formula to another language:
https://www.ibm.com/docs/en/order-management-sw/9.3.0?topic=cpms-handling-credit-cards