It would have been helpful if you had mentioned a dollar figure.
Most people want an ultra thin camera.
But that is not a good choice.
You need a camera with manual controls.
Because a camera in automatic mode will usually choose the wrong settings, in low light situations.
This means you will need to learn how to use those manual controls.
It is nice to have a camera with a very bright lens.
Something like a f-stop specification of f2.0
But there are only two of those - Canon G6 and Sony F828. Both cost over $500.
Among the less expensive smaller cameras, the Canon "A" series of cameras will work in low light situations (A75, A85, A95).
The A75 has been replaced by the new A510.
The A85 has been replaced by the new A520.
When looking for a camera, look for two things in the specifications:
Shutter Priority
Aperture Priority
If the the camera has those features, it will have the necessary manual controls to work with low light.
If you are looking for a low light camera with a large zoom, look at any of the long lens Panasonic Cameras.
The very best cameras for low light are the very expensive cameras that cost over $1,000.
...
..
.
Hello there,
I have been doing some research on digital cameras for about two months now. Cnet.com has become my second net-home. Basically, I am looking for a camera that performs well in low light conditions such as concerts, restaurants and bars.
I was wondering if anyone out there would be willing to give me some advice.
Thank you very much.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic