Not logged in - Login / Register

View History

CLR Reference: Dynamic Credit Card

"Credit Card Dynamic"

CLR function


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.



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