Hi All,
I am trying to mask the card data for PCI compliance and the requirement is to mask the in between 6 digits of card leaving the first 6 digits of card which are bin numbers and last 4 digits of card which are unique in tact.
From few blogs and sites I could find we can use regular expression and UDF for that but I am unable to get the correct syntax for that,Can somebody help me in getting the exact syntax for doing that and also this should be consistent across database.
Thanks in advance.
Regards/vinay