Is telling a Lie bad or good?

Telling a LIE or Twisting the truth is it really wrong???? When u ask a Dr if you going to be ok. He does not say " no you dying" they try an comfort you even at the worst point. When someone needs motivation. You can lie to boost there ego to help them. We lie about santa clause to kids. We lie about the tooth fairy. So is lying really all bad????