QUESTION POSED ON: 10 January 2006
I have a question about comparing encrypted column values. Here is the logic:
1. Data in column A in table T1 is encrypted
2. Data in column B in table T2 is normal text. Its size is varchar(6)
3. One of the conditions in our WHERE clause is to compare first 6
characters of column A in table T1 with column B in table T2
How do I acheive that? Is there a SQL Server built-in function for the
encryption/decryption process I could use here? The query is part of a stored procedure. Triple
DES is the algorithm used for data encryption. We are using SQL Server 2000.
|
