MASK_HASH

Returns a consistent hash value based on the input string. This function returns NULL for non-string types.

Syntax

MASK_HASH(expression varchar) → varchar

• expression: The string to hash.

Examples

MASK_HASH example

SELECT MASK_HASH('abcd-ABCD-1234')
-- 770d599256e3902a0aacc9750cd1ca7f34be182632ba3dca3d2eb6f31dcc3d59