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 NAME<<userID>>
, So the end result should look like NAME1
Is this possible in SQL Server?
My SQL Server details below.
I have tried these methods from the documentation but still no luck from documentation