SELECT
REPLICATE('*',LEN(REPLACE(REPLACE(LTRIM(RTRIM(CARDNUMBER)),CHAR(9),''),' ',
'')) -4) +
RIGHT(REPLACE(REPLACE(LTRIM(RTRIM(CARDNUMBER)),CHAR(9),''),'
', ''),4) ,LTIMESTAMP
FROM ARCHOWN.ONLINE_CARDS
--where ltimestamp between
'2024-12-31' and '2025-03-11'
WHERE LTIMESTAMP >=
'2024-12-31' AND CARDNUMBER NOT LIKE '%[*]%'
No comments:
Post a Comment
If you have any doubt or question, please contact us.