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;