deejay1-
The Radio Shack advice you got is reasonably good. The smaller the f-number, the more light a lens will let in. And that does make a big difference with low light shooting. However, compact cameras have other limitations that could make a bigger difference. While it's true that a small F-stop / larger aperture will let more light in, the tiny sensors in pocket digital cameras generally have poor low light performance. The photos you take with a compact camera in low light will have lots of digital noise - or grain. The truth is, there aren't any pocket cameras that really "excel" at low light photography. If you want great low light results you're going to have to spend a ton for a good digital SLR.

That doesn't mean you can't get good results in low light from a pocket camera, though. Buy the best quality pocket camera you can and learn how to get the best in low light and you'll get some great photos. But you may have to adjust your expectations and you'll definitely have to learn some tricks to get good photos. Don't expect the camera to just take awesome photos in a club, right out of the box.

So why don't you tell us some more so we can help you choose a camera. How big are you willing to go? What's your budget? Do you have any brand preferences? What are you shooting with now? And what kind of photos do you want to take? The more specific you can be the better