I am looking for a good compact digital camera and I’m happy to pay up to £200 for it.

I’d be taking it to nightclubs so a nice flash would be useful.

I also like taking general amateur photos, so a decent macro mode and some manual controls would be handy also.

Any ideas?