The lens isn't CMOS/CCD, that's the sensor.

The lens is important but the sensor is probably tiny on the dash which is causing the problem.

Ah, the sensor, thats what I was thinking of.
As I suspected if the sensor isn't up to the job changing the lens won't make a difference.

No, you'd need to change the sensor. This is most easily achieved by buying a new camera.