I'm pretty sure this is the same camera one of my friends bought in a similar deal at compusa last summer...
Pics seemed "green" tinted slightly. I'm not sure if there's any settings you could adjust -- like white-balance or maybe and "indoor"/"outdoor" lighting mode.
My impression is: Not terrible for a low-end camera that won't kill you if it gets lost/stolen.
Personally, if you like taking pics, I'd save up a little more for a panasonic, fuji, olympus or canon. The low-end cams (if you can find them) should be had on sale/AR for $20 more than the concord.
LINK for the lazy.
Pluses: 2 AA batteries , 50 INSTANT rebate... so no hassle (The compusa thread for this week has a link to the 50-off coupon/flyer, so you could pick it up in-store rather than delivered)
(ignore all claims of "total zoom" -- it's 3x optical... just a peev of mine)