CLR Data Masking Components
CLR Reference
CLR Data Masking Components
Open Navigation Article
VIN Dynamic
CLR function
SQLCLR:
SELECT [dbo].[VINDynamic] (<@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].[VINDynamic] ('SCA682D57FUX00000')
×
CLR Reference: VIN Dynamic
CLR Reference: VIN Dynamic
- 1. VIN Dynamic
- 1.1 CLR function
- 1.2 Expected input
- 1.3 Expected output
- 1.4 Error handling
- 1.5 Example
CLR Data Masking Components
CLR Reference