Well I tried that and it did work.

But I am trying to do the Encryption on a INSERT or UPDATE of a table

When I put the OPEN MASTER KEY/Encrypt statements in a trigger to encrypt any incoming data and have the decrypt OPEN MASTER KEY/decrypt statements in a Procedure I get a NULL on the decryption.

So I was trying moving the OPEN MASTER KEY/encryptiondecryption statements into Functions to see if that would work.

The other downfalls to putting into Procedures are that:

-I would like to not have this functionality scattered into many SPs

-I wish to Encrypt on a trigger

Regards GF