e
q
u
e
s
t
a
d
e
m
o < back
CLR Reference: VIN
{TOC}**{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')