For wide to moderate telephoto you need a 28-55mm,
28 is bearly wide angle on any reasonably priced DSLR (as in not the Canon 5D or 1Ds).
To get the same field of view as a 28mm would give you on 35mm film you need 18mm on the DSLRs you are looking at.
28mm gives you an equivalent fov of a 43mm lens on film, which is basically a standard lens.
The standard kit lenses which come with the current lineup of DSLRs from Nikon, Canon and Pentax are all 18-55 which makes a good close (but not super close) range lens.