 |
Data Mask SQL |
| Home | |
|
Transform.FindReplace Sample SQL... /*=================================================================================== Mask Type: Transform.FindReplace =====================================================================================*/ /*--------------------------------------------------------------------- Table: [dbo].[DimCurrency] Column: [CurrencyName] Mask: * Type: 'Transform: Find/Replace...' * Params: 'US|Mexico' * Category: 'Transform' - Overwrite all rows with an "obsfucated" original value * Descrip: This mask transforms each row by finding a string you specify and replacing it with a different string you specify. ---------------------------------------------------------------------*/ UPDATE [dbo].[DimCurrency] SET [CurrencyName] = REPLACE([CurrencyName], 'US', 'Canadian') |
