luhn_check function
Applies to: Databricks SQL
Databricks Runtime 13.3 LTS and above
Returns true if numStr passes the Luhn algorithm check.
The Luhn algorithm is used for example, to validate creditcard numbers.
Syntax
luhn_check(numStr)
Arguments
numStr: An STRING expression composed of digits'0'through'9'.
Returns
A BOOLEAN.
If numStr contains any character that is not a digit the result is false.
If the input's last digit matches the algorithm the result is true
Examples
SQL
> SELECT luhn_check('12345');
false
> SELECT luhn_check('12344');
true
> SELECT luhn_check('1234 4');
false