The TripleDes key needs a byte[] which is known at both ends. They are using MD5 to create the byte[] value from a shared string.....

>Is that some sort of double layer of encryption ?
>
>They are MD5 encrypting the key then using that value to encrypt the actual data ?
>
>>>>>Hi
>>>>>
>>>>>I'm being passed some data encrypted with MD5.
>>>>>
>>>>>I can find examples of how I encrypt in TSql
>>>>>
>>>>>SELECT CONVERT(NVARCHAR(32),HashBytes('MD5', 'email@dot.com'),2)
>>>>>
>>>>>but I can't find an example of how I would de encrypt the result to get the original content.
>>>>
>>>>You can't - it's just a hash value....
>>>
>>>Hi Viv
>>>
>>>I'm being passed some data which I've been told is MD5 encrpted
>>>
>>>they've also passed me some c# code which has encryption and decryption functions.
>>>
>>>Is that not the same thing ?
>>>
>>>Nick
>>>
>>>
>>>using System;
>>>using System.Collections.Generic;
>>>using System.Linq;
>>>using System.Text;
>>>using System.Security.Cryptography;
>>>
>>>namespace Unified.ram.Common.Util
>>>{
>>> public class EncryptDecrypt
>>> {
>>> public static string Encrypt(string strToEncrypt)
>>> {
>>> string key = Sitecore.Configuration.Settings.GetSetting("EncryptDecryptKey", "");
>>> return Encrypt(strToEncrypt, key);
>>> }
>>>
>>> public static string Encrypt(string strToEncrypt, string strKey)
>>> {
>>> try
>>> {
>>> TripleDESCryptoServiceProvider objDESCrypto =
>>> new TripleDESCryptoServiceProvider();
>>> MD5CryptoServiceProvider objHashMD5 = new MD5CryptoServiceProvider();
>>> byte[] byteHash, byteBuff;
>>> string strTempKey = strKey;
>>> byteHash = objHashMD5.ComputeHash(ASCIIEncoding.ASCII.GetBytes(strTempKey));
>>> objHashMD5 = null;
>>> objDESCrypto.Key = byteHash;
>>> objDESCrypto.Mode = CipherMode.ECB; //CBC, CFB
>>> byteBuff = ASCIIEncoding.ASCII.GetBytes(strToEncrypt);
>>> return Convert.ToBase64String(objDESCrypto.CreateEncryptor().
>>> TransformFinalBlock(byteBuff, 0, byteBuff.Length));
>>> }
>>> catch (Exception ex)
>>> {
>>> return "Wrong Input. " + ex.Message;
>>> }
>>> }
>>>
>>> public static string Decrypt(string strEncrypted)
>>> {
>>> string key = Sitecore.Configuration.Settings.GetSetting("EncryptDecryptKey", "");
>>> return Decrypt(strEncrypted, key);
>>> }
>>>
>>> public static string Decrypt(string strEncrypted, string strKey)
>>> {
>>> try
>>> {
>>> TripleDESCryptoServiceProvider objDESCrypto =
>>> new TripleDESCryptoServiceProvider();
>>> MD5CryptoServiceProvider objHashMD5 = new MD5CryptoServiceProvider();
>>> byte[] byteHash, byteBuff;
>>> string strTempKey = strKey;
>>> byteHash = objHashMD5.ComputeHash(ASCIIEncoding.ASCII.GetBytes(strTempKey));
>>> objHashMD5 = null;
>>> objDESCrypto.Key = byteHash;
>>> objDESCrypto.Mode = CipherMode.ECB; //CBC, CFB
>>> byteBuff = Convert.FromBase64String(strEncrypted);
>>> string strDecrypted = ASCIIEncoding.ASCII.GetString
>>> (objDESCrypto.CreateDecryptor().TransformFinalBlock
>>> (byteBuff, 0, byteBuff.Length));
>>> objDESCrypto = null;
>>> return strDecrypted;
>>> }
>>> catch (Exception ex)
>>> {
>>> return "Wrong Input. " + ex.Message;
>>> }
>>> }
>>> }
>>>}
>>
>>Looks like that is using TripleDES for the encryption with a MD5 hash as the key ? No idea how you can go about decrypting in SQL tho :-{