You cannot get HD signal quality over RF modulation cables. You must have either Component (Red Green Blue) or HDMI on the back of your TV. If your cable box is old then its probably not HD. DVDs are not HD quality but will look good over Component or S-video.
If you can avoid using RF cable...