ADMIN_GenerateModulus10CheckDigit

 Show all Hide all

Deprecated.

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.

Parameters:

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