QUA_SHUFFLE

Reworks data and produces its pseudonymized counterpart. This function is commonly used to create the data representation which looks obscure and thus hides sensitive information.

Syntax

QUA_SHUFFLE ( expression, seed )

Arguments

expression

Is an expression of the supported type. The following table lists all valid data types.

  • int, smallint
  • tinyint, bigint
  • money, decimal
  • real, float
  • datetime, date
  • time, datetime2
  • uniqueidentifier, smalldatetime
  • varchar, nvarchar
  • char, nchar
  • bit

seed

Integer value of seed to use.

Return types

Returns the same type as expression.

Remarks

NULL value always returns NULL.

QUA_SHUFFLE has specific behavior when a date is concerned:

  • always produces the same age;
  • respects leap years;

Examples

SELECT qua_shuffle(cast('b97a792a-f791-42a6-a8ee-01a3e8a6ef88' as uniqueidentifier), 123456) as HiddenGuid;