Canon Power shot SD 900-Sony N2=which is best to take crystal clear photos-give any other models if any?

Answer 1

For the SD900, check the reviews here: http://www.dpreview.com/reviews/read_opinions.asp?prodkey=canon_sd900

For the Sony N2: http://www.dpreview.com/reviews/specs/Sony/sony_dscn2.asp

Here's a very revealing side-by-side comparison: http://www.dpreview.com/reviews/compare_post.asp?method=sidebyside&cameras=canon_sd900%2Cfuji_finepixf31fd%2Csony_dscn2&show=all

As a note, don't get hung up on cameras with more that 6mp. Might help a little, but not as much as you might think due to the small sensors and lens limitations in compact digitials.