Using Dynamic Data Masking in SQL Server set Custom String
0
votes
1
answer
168
views
I need to mask the data in the following table.
For example, I need to mask the first_name of the user Roberto to something like
I have tried these methods from the documentation but still no luck
[from documentation](https://learn.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15#defining-a-dynamic-data-mask)

NAME>
, So the end result should look like NAME1
Is this possible in SQL Server?
My SQL Server details below.

Asked by ravindu wijepala
(11 rep)
Mar 26, 2021, 11:48 AM
Last activity: Mar 26, 2021, 03:13 PM
Last activity: Mar 26, 2021, 03:13 PM