Thank you so much Steve and Sean.

As I was seraching for solution intially, when i got this task, i found single column encryption can be the best solution for this.

and I though I have some academic knowledge about encryption , so I can make it possible.

But now It seems that , it is alsmost near to impossible.

as far as I know from all our conversation is that , all our user has to work on the same server , so there is no point to do the single column encryption, because symmetric key and certificate will be there on the same server , so any of us(user) can decrypt that data.

can you please let me know more about , why encryption is not the proper solution for this issue..?

So that I can explain to my senior manager, as i told him earlier that encryption can be the solution, without understandig, the system and encryption thourghly.

Please.