Not logged in - Login / Register


R
e
q
u
e
s
t

a

d
e
m
o
< back

CLR Reference: VIN

**

"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')

Download a Trial