CLR Reference: Dynamic Credit Card

Request
a trial
Request
a demo
Request
a quote

CLR Data Masking Components

All articles

CLR Reference

Dictionary Substitution

Full Name Info Dynamic

Generic Alpha Numeric

Generic Alpha Numeric Dynamic

Generic Phone Nu

Generic Phone Nu Dynamic

Names With Gender Dynamic

State Province Dynamic

Start a Trial

CLR Data Masking Components

CLR Reference: Dynamic Credit Card

Request
a trial
Request
a demo
Request
a quote

API Reference

SSIS Reference

Credit Card Dynamic

CLR function

SQLCLR:

SELECT [dbo].[CreditCardDynamic] (<@creditCard, nvarchar(4000)>)

Expected input

Data: Credit card number including separators (Letters are not allowed). Digits count must be between 13 and 20.

Expected output

Credit card number of the same length and separators positions with LUHN validation string (nvarchar(MAX))

Error handling

Fails on empty or Null values. Fails on values that contains less than 13 digits or more than 20 digits.

Example

SQLCLR:

SELECT [dbo].[CreditCardDynamic] ('12345 554 512345')

CLR Reference: Dynamic Credit Card

1. Credit Card Dynamic
1.1 CLR function
1.2 Expected input
1.3 Expected output
1.4 Error handling
1.5 Example

Download Manual