Masking Confidential Data in SQL '05 Table

[GeekToMe]

Greeting!

I am loading data files that we are receiving from an external client into a SQL Server 2005 database and have been asked to mask confidential fields such as Social Security Numbers, Account Numbers, etc. (i.e. display '****' in the tables). I'm certain this can be done but I'm having trouble finding information on how to do it. Can anyone help get me going in the right direction?

Thanks in advance!

Nate

 

[ca8msm]

[google]sql server encryption[/google] would be a good starting point.



-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]