Is there any way masking a column with list of values without changing datatype?

  • 0
  • 1
  • Question
  • Updated 2 months ago
For example, I want to mask list of values from a column whose datatype is NVARCHAR(-1). When I tried masking it using SL algorithm, irrespective of the given list of values the entire column is replacing with character 'm'. 
I tried changing datatype to NVARCHAR(4000) and used SL then masking worked fine.

Basically, we are not supposed to change the datatype.

Now, I want to mask the listed values of a column using SL without changing datatype. Is there a way to sort out this issue?
Photo of Rajesh Dadi

Rajesh Dadi

  • 402 Points 250 badge 2x thumb

Posted 2 months ago

  • 0
  • 1

Be the first to post a reply!