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
Should developers be granted permissions to production queue in a SQL Server environment? See why expert Greg Low suggests proc access by WITH ...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
If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know.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.