0

I'm using the SQL Dynamic Masking on columns in my table (LastName, SecondaryLastName). Those columns both contain the same masking function.

Function: MASKED WITH(FUNCTION = 'partial(1,"***", 1)')
Both LastName and SecondaryLastName Column Values from Mask:
H***M

I also have a computed column that performs this check ISNULL(LastName, SecondaryLastName). The Computed column value displays as below. Why does it not carry the masking display from the actual columns used in the computation?

Computed Column Value:
XXXX

Why will the computed column not carry through the Masked value?

billy_comic
  • 867
  • 6
  • 27
  • Cross site duplicate candidate: [Dynamic Data Masking Issue when Concatenating Fields](https://dba.stackexchange.com/questions/278213/dynamic-data-masking-issue-when-concatenating-fields) – Thom A Apr 05 '23 at 14:54

0 Answers0