Skip to content

Latest commit

 

History

History
47 lines (36 loc) · 1.72 KB

mask_last_n.md

File metadata and controls

47 lines (36 loc) · 1.72 KB
description
Returns a masked version of a string with the last num_chars characters masked. By default, if you do not provide a mask value, the last four characters are masked.

MASK_LAST_N

Syntax

MASK_LAST_N(expression varchar, num_chars int, uc_mask varchar, lc_mask varchar, num_mask varchar) → varchar

  • expression: The string to mask.
  • num_chars: The number of characters to mask.
  • uc_mask: Controls the mask character for upper case letters.
  • lc_mask: Controls the mask character for lower case letters.
  • num_mask: Controls the mask character for numbers.

Examples

{% code title="MASK_LAST_N example" %}

SELECT MASK_LAST_N('abcd-ABCD-1234')
-- abcd-ABCD-nnnn

{% endcode %}

{% code title="MASK_LAST_N example containing optional mask value." %}

SELECT MASK_LAST_N('abcd-ABCD-1234', 2)
-- abcd-ABCD-12nn

{% endcode %}

{% code title="MASK_LAST_N example containing optional arguments." %}

SELECT MASK_LAST_N('abcd-ABCD-Aa12', 4, 'U', 'u', '#')
-- abcd-ABCD-Uu##

{% endcode %}

Usage Notes

By default, upper case letters are converted to X, lower case letters are converted to x, and numbers are converted to n. You can override the characters used in the mask by supplying optional arguments. The second argument controls the mask character for upper case letters, the third argument for lower case letters, and the fourth argument for numbers.

\