A multi-wavelength analysis of interstellar CN: comparison of red and violet absorption line observations