0

I need to mask the data in the following table. enter image description here

For example, I need to mask the first_name of the user Roberto to something like NAME<<userID>>, So the end result should look like NAME1

Is this possible in SQL Server?

My SQL Server details below.

enter image description here

I have tried these methods from the documentation but still no luck from documentation

mustaccio
  • 28,207
  • 24
  • 60
  • 76
ravindu wijepala
  • 11
  • 4

1 Answers1

1

You cannot refer to data in some other column so if that 1 should come from the MemberId column, then you are out of luck. What you have to play with are the prefix and suffix, and those need to be from the same column as the masking is defined on.

Tibor Karaszi
  • 18,269
  • 2
  • 17
  • 30