Show all Hide all

This function answers the question whether a given string representing an integer is modulus 10 check compliant (ie. whether the last digit of its modulus 10 checksum i zero).

This is thus the check to use as part of validating the integrity of any modulus 10 encoded integer string such as a social security number or an OCR-number.

If the string to check is either null or if it contains any character that is not a digit then the function will return a value of null.

Type: Scalar function
Area of use: General use

Return value: bit

Returns 1 if string is modulus 10 check compliant and 0 otherwise.


@IntegerString mandatory varchar(8000)
The integer string for which to check for modulus 10 compliance.