Thanks for reply.

I agree with your explanation and I do follow as you said. Can you tell me if there is any performance gain, if I maintain the length of VARCHAR as per requirement. I want to convince my manager that VARCHAR(2000) is really not required everywhere.