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 lyft_shuffle(cast('b97a792a-f791-42a6-a8ee-01a3e8a6ef88' as uniqueidentifier), 123456) as HiddenGuid;