12-08-2011 09:12 AM
GO
OPEN SYMMETRIC KEY KWTableKey Dectyption
BY CERTIFICATE EncryptKWCert
SELECT CONVERT(NVARCHAR(50),DECRYPTBYKEY(EncryptedSSN)) AS DecryptedSSN
FROM KWData WHERE Last_Name =
'Smith'
Thanks
12-08-2011 09:20 AM
Have you tried it?
12-08-2011 09:25 AM
No, I'm just being asked for requirements purposes. I'll give it a try if that's the only way I'll find out.
12-08-2011 09:32 AM
I haven't tried, but my gut tells me it probably won't work. I figured it would be fastest to just throw it into a test system and see if it works.
12-08-2011 09:36 AM
Ok, I'll post back here after I test it. If it doesn't work, is there an alternative?
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.