Mike
You'll get a decent compact for that, or a bargain DSLR if you're lucky.
One thing to check though if you're tempted by a compact, is the time taken between you telling the camera that you'd like it to take a photo, and it taking it. Our sony compact takes .5 to 1 second, even if you've got it ready by pressing the button 1/2 way down. This doesn't seem long, but in reality is an age if you're trying to snap a car at 150 mph, or an energetic child.
Try them out in a shop, don't leave this to chance.