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;