CLR Data Masking Components
CLR Reference
CLR Data Masking Components
Open Navigation Article
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')
×
CLR Reference: VIN
CLR Data Masking Components
CLR Reference