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 the first 6 characters of column A in table T1 with column B in table T2
How do I acheive that? Is there any built-in SQL Server function for encryption/decryption? The query is part of stored procedure. Triple DES is the algorithm used for data encryption. We are using SQL Server 2000. Any help is greatly appreciated!
Related Q&A from Greg Low
Learn why using the sp_OACreate stored procedure with a SQL Server 2005 trigger, is likely to result in a permissions problem.continue reading
A SQL Server application that needs user permission to create and modify tables in SQL Server 2005 may be handled best via a schema.continue reading
Find how to query in SQL Server to get all database names created by users.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.