CLR Reference: VIN

**{TOC}

"VIN"

CLR function

SQLCLR:

SELECT [dbo].[VINRandom] (<@vin, nvarchar(4000)>)

Expected input

Data: Valid Vehicle Identification Number

Expected output

Generic VIN (nvarchar(MAX))

Error handling

Returns an empty string when passing empty or NULL value. Fails on invalid VIN format

Example

SQLCLR:

SELECT [dbo].[VINRandom] ('SCA682D57FUX00000')