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.