For what you're willing to spend, you should be able to find a VERY good mid-range camera. Depending whether it's US or CAD currency, ofcourse. Either way, I can suggest taking a look at Canon and Kodak, as IMHO they have some very good digicams and are 'affordable'.
WHat you want is a minimum of 3 megapixels, and some decent onboard memory. Also, take a look at what kind of memory peripherals the camera will take. For example, Sony camera's use Sony's own proprietary memory sticks, which is a good way to rob you of even more money, so go with a camera that takes generic standards memory.