alsamflux
dvysotskiy
/ UDF_VALIDATE_VIN.sql
Last active
August 2, 2023 12:18
SQL Server function to validate vehicle identification numbers (VIN) using length, format, and checksum rules.
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 |