Maskowanie pobranych danych (SQL Server 2016) http://www.codeproject.com/Articles/1111938/SQL-New-Features
//here I used function as Default(), you can change it to any of the above types
ALTER TABLE tablename ALTER COLUMN columnname MASKED WITH (FUNCTION=‚default()‘)