Windows Test Gear - MSSQL.DataMask - Transform.PrefixSuffix Sample SQL

	Data Mask SQL
	Home

Transform.PrefixSuffix

Sample SQL...

/*===================================================================================
Mask Type: Transform.PrefixSuffix =====================================================================================*/
/*---------------------------------------------------------------------
Table: [dbo].[DimAccount]
Column: [CustomMembers]
Mask:
* Type: 'Transform: Prefix/Suffix...'
* Params: 'Member.|.Trail'
* Category: 'Transform' - Overwrite all rows with an "obsfucated" original value
* Descrip: This mask transforms each row by adding a prefix and a suffix (you
specify in parameters) to the existing text value in each column.
---------------------------------------------------------------------*/
UPDATE [dbo].[DimAccount]
SET [CustomMembers] = LEFT('Member.' + [CustomMembers] + '.Trail', 300)