 |
Data Mask SQL |
| Home | |
|
Transform.AsteriskMask Sample SQL... /*=================================================================================== Mask Type: Transform.AsteriskMask =====================================================================================*/ /*--------------------------------------------------------------------- Table: [dbo].[DimAccount] Column: [Operator] Mask: * Type: 'Transform: Asterisk Mask...' * Params: '5' * Category: 'Transform' - Overwrite all rows with an "obsfucated" original value * Descrip: This mask transforms each row by obscuring the leftmost N characters with asterisks; where you specify the length of N. ---------------------------------------------------------------------*/ UPDATE [dbo].[DimAccount] SET [Operator] = STUFF([Operator] , 1 , 5 , REPLICATE('*', 5)) |
