I mentioned earlier that I'm joining jazz band. But I'm not quite sure what kind of bass to look at.

I'm looking for one that's good for jazz (duh) and one that could also handle some good rock.

My favorites are Fender P and Jazz Bass'