column Data to be masked with custom length of characters

Hi Team , 
we have a Account Number column with fixed 6 Digit length . Expectation is like Account Number to be masked with same fixed 6 Digits length . But current masked dataset we have 9 Digits .. please suggest the way .

Best Answer

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    Hi @vinay11
    As previously advised in an earlier forum post you submitted.

    Use the 'Number, Luhn,Mod(10)' DataSet and set the total digits in number to be 6 (where the default value is set to 10).

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com

Answers

Sign In or Register to comment.