Triple DES Encryption Custom Key and IV

[benwizzle]

Is there a way to encrypt/decrypt in SQL using your own defined Key and Initialization Vector. I have a stored procedure that uses an encrypted field and of course it doesnt return anything because I encrypted the value inside my web app before saving it to my database.

Any ideas/thoughts appreciated.

[ck9663]

If that field is sensitive enough for you to encrypt it on your front-end, you should also encrypt that on your database.

Here's an idea.

Happy Coding!!!

~~ CK

[benwizzle]

To explain what I am doing more. I have a crystal reports viewer linked to a report that takes in the parameter.
The only way for the stored procedure to return a match is if that parameter is passed into the select statement with the Key and IV I used in the app at saving time. That field is constantly encrypted and decrypted many times in my app, so encrypting it permanently does not help me.

Basically im just trying to find a way to either have my stored procedure encrypt the input from the parameter prompt or somehow find a way to encrypt the input before it gets passed to the stored procedure through the CrystalReportVi ewer so that the stored procedure will return a match.