Show all Hide all


This function takes an integer string and generates the check digit to append to the end of it in order to make the string pass a modulus 10 integrity check.

This is the kind of integrity check used for things such as social security numbers and OCR-numbers.

If the input string 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: int

The generated check digit.


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