Categories: String
MASK_SHOW_LAST_N
Returns a masked version of a string with the last num_chars
characters unmasked. By default, if you do not provide a value, the last four characters are shown.
Syntax
MASK_SHOW_LAST_N(expression varchar [, num_chars int] [, uc_mask varchar] [, lc_mask varchar] [, num_mask varchar]) → varchar
- expression: The string to mask.
- num_chars (optional): The number of characters to unmask.
- uc_mask (optional): Controls the mask character for upper case letters.
- lc_mask (optional): Controls the mask character for lower case letters.
- num_mask (optional): Controls the mask character for numbers.
Examples
MASK_SHOW_LAST_N exampleSELECT MASK_SHOW_LAST_N('ab12-ABab-1234')
-- xxnn-XXxx-1324
SELECT MASK_SHOW_LAST_N('ab12-ABab-1234', 2)
-- xxnn-XXxx-nn34
SELECT MASK_SHOW_LAST_N('Aa12-ABab-1234', 4, 'U', 'u', '#')
-- Uu##-UUuu-1234
SELECT MASK_SHOW_LAST_N('abcd-ABCD-1234', 2, '', 'u', '')
-- uuuu-XXXX-nn34