This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE FUNCTION dbo.UDF_VALIDATE_VIN(@VIN varchar(17)) | |
RETURNS @RESULT TABLE | |
( | |
IS_VALID BIT NOT NULL, | |
LENGTH_VALID BIT NOT NULL, | |
FORMAT_VALID BIT NOT NULL, | |
CHECKSUM_VALID BIT NOT NULL, | |
CHECK_DIGIT CHAR(1) NULL, | |
PRODUCT INT NULL, | |
REMAINDER INT NULL |