Loading

Card number masking

sathish

8y893

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?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Manish Kumar8y ago
Which version of Sql server you are using. If 2016 then check below link for data masking for sensitive data.

http://www.c-sharpcorner.com/article/masking-sensitive-data-with-sql-server-2016/
0