Card number masking

Feb 16 2018 3:31 AM

Hi,

I have a 1000+ comment in DB as "your blocked card numbers: 1234567892345676, 8765876545676456" .

Here I have to update this 1000 records with mask of numbers like - "your blocked card numbers: ************5676, ************6456" .

How to achive this in a one update datascript in SQL?

Answers (1)

rotational shift change