Hello man.

This question is very relevant. In my tests, I also found that + operator and CASE operator dont behave according the expected.

In the BOL, the CASE operator it used...

Very good.

I was searching for someone that explain the why in sql server exists a "herarchy" for crypt data...

After you give the example of encryption using pass phrase and encryption...