DECLARE @CreditCardNumber VARCHAR(20)
SET @CreditCardNumber = '170202199408103544'
SELECT STUFF(@CreditCardNumber, 7, 8,'XXXX')
DECLARE @CreditCardNumber VARCHAR(20)
SET @CreditCardNumber = '170202199408103544'
SELECT STUFF(@CreditCardNumber, 7, 8,'XXXX')