Take a look at the following websites:
http://www.dpreview.com/
http://www.steves-digicams.com/
There's a LOT of good info there.
You'll need to decide:
* How much money you're willing to spend
* How large of a picture you want to take (megapixels).
* What you want to use it for (macro shots, general purpose photography, etc)
* If you want to be able to take the photos into Kmart, Walmart, etc on CD and be able to print off 3x5 photoquality pics (this generally relates to the megapixel capability of the camera)
* etc...
From everything that I've read so far, the Nikon Coolpix 9xx series has one of the best macro capabilities of the cameras out there. However, I prefer the feel of holding an SLR camera and based on dpreview's comments on the Sony 3.3 and 5 megapixel cameras, I'm seriously considering either the 505 or 707. Kinda spendy, but the image size and quality puts it over the top for me.
Also, there was a talk on #reefs about a year ago about photographing your aquarium. Discussed equipment, cameras, techniques, etc:
http://www.reefs.org/library/talklog/ops_photo_talk_013101.html
Shane
liquid on #reefs
[ January 02, 2002: Message edited by: LiquidShaneo ]</p>