With SQL Server 2016 released you can now mask your data / columns in such a way that users with valid permissions can only see the
actual data whereas other will see he masked data as per the configuration. Download Script Here. DataMask
Create a user with Datareader permission and see the results after connecting from that user.