ADMIN_IsValidOCRNumber

Show allHide all

Deprecated. Don't use for new development and try to migrate existing uses.

Type: Scalar function

This function answers the question whether a given string is a formally valid OCR-number.

If the OCR-number includes a length check digit then length validation should be enabled by setting the second input argument appropriatly.

Return value: bit

Returns 1 if the OCR-number is formally valid and 0 otherwise.

Parameters

@OCRNumber mandatory varchar(8000)
The OCR-number to validate.
@IncludesLengthCheckDigit mandatory bit
Set to 1 if the OCR-number should include a length check digit and you want to perform a length check validation on top of the normal validation.