PARTIAL_STRING_MASK
This string masking function provides the ability to reveal the first and the last few specified number of characters with a custom padding string in the middle.
Syntax
partial_string_mask(<str>, <prefix> ,<padding> , <suffix>)
Remarks
• <str> is the string to be masked.
• <prefix> is the starting number of characters to be revealed.
• <padding> is the custom padding string in the middle.
• <suffix> is the last number of characters to be revealed from the column value.