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