SQL Puzzle: SQL Advance Query - Use STUFF() and Mask the Credit Card Number

SQL Puzzle: SQL Advance Query – Use STUFF() and Mask the Credit Card Number

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

Check the below input data and expected output to Mask the Credit Card Number.

Sample Credit Card Number:

1	8168888888521458

Expected Output:

Result

--------------------

XXXXXXXXXXXX1458

Solution:

DECLARE @CreditCardNo VARCHAR(20)

SET @CreditCardNo = '8168888888521458'

SELECT STUFF(@CreditCardNo, 1, LEN(@CreditCardNo) - 4,

REPLICATE('X', LEN(@CreditCardNo) - 4)) AS Result

Please try the different solution for this puzzle and share it via comment...

Aug 28, 2017Anvesh Patel

Comments: 1

Dinesh

August 30, 2017 at 12:06 pm

Solution -2

DECLARE @CreditCardNo VARCHAR(20)
SET @CreditCardNo = ‘8168888888521458’

Select Replicate(‘X’,Len(@CreditCardNo)-4)+Right(@CreditCardNo,4) As Result

SQL Puzzle: SQL Advance Query – Use STUFF() and Mask the Credit Card Number