There is a column in one of our table that stores SSN of the client-end-users.I suggessted using the DENY DCL-feature, such that permissions to that column itself is resticted to groups of people that have access to the data, like db developers. However, we are asked to prepare an update script instead of going to DCL permission levels. Is there any other technique on how one can mask one particular column of a table in a database? Will using hashing algorithms like HASHBYTES, CHECKSUM or BINARY_CHECKSUM help? If yes, how?