Post
Ask Question

Show only Last Four Digit of Credit/Debit Card Number

  1. DECLARE @Val VARCHAR(56)='1234456178949871' ,@Val2 VARCHAR(56)  
  2. SELECT @Val2=ISNULL(REPLICATE('X',LEN(@Val)-4),'X')+RIGHT(@Val,4)  
  3. SELECT STUFF(STUFF(STUFF(@Val2,5,0,' '),10,0,' '),15,0,' ')