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.
Dig deeper on SQL Server Security
Related Q&A from Steven Andres
Learn how to create a SQL Server user authentication schema having password and tracked data changes requirements and how it involves Windows ...continue reading
Find how to create a SQL Server 2000 login account and then set user account rights to specific databases with "db_owner."continue reading
Learn why SQL Server 2000 connection is lost on the client side when database administrator changes 'SA' password on the SQL Server domain.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.