DECLARE @SecurePass nvarchar(4000); SELECT @SecurePass = CONVERT(nvarchar(4000),'Vithal'); SELECT HashBytes('SHA1', @SecurePass);

Respected Sir, Please check the following website related to your problem.http://dpatrickcaldwell.blogspot.in/2010/10/column-encryption-in-sql-server-2008.html