What type of night shots are we talking about? Are you looking at low light shooting of people or are you wanting to shoot more of landscape or scene shooting?
I am willing to spend about $500 (I guess) on a new camera. Do you have any suggestions for a digital camera that can take great shots during the day and night shots, too? I have been using a Canon PowerShot SD750, which I really like, but it is time for a new camera that can do more.
Thanks,
Mark

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic