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

	Data Mask SQL
	Home

Transform.Truncate

Sample SQL...

/*===================================================================================
Mask Type: Transform.Truncate =====================================================================================*/
/*---------------------------------------------------------------------
Table: [dbo].[DimAccount]
Column: [CustomMemberOptions]
Mask:
* Type: 'Transform: Truncate'
* Category: 'Transform' - Overwrite all rows with an "obsfucated" original value
* Descrip: This mask transforms each row by truncating all characters to the right
of the character position you specify in the parameter.
---------------------------------------------------------------------*/
UPDATE [dbo].[DimCustomer]
SET [Title]
= LEFT([Title]
, 6);