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
10-31-2013 08:06 AM
Greg,
Although you may have already gotten the asnwer to you issue Hyland is making an effort ensure that all forum posts have an "ansered" solution. So, for the benefit of others we would like verify that your issue was resolved.
The SQL box of the External Autofill should be able to handle your request. That box should not restrict any SQL that is there. It shold simply return the same results as it would if you executed it directly against the SQL database. If this is not case, please feel to contact your first line of support for further assistance.
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.