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

> SELECT luhn_check('12345');
 false

> SELECT luhn_check('12344');
 true

> SELECT luhn_check('1234 4');
 false

Related

• sha function