The only correct code to return everything for november, nothing less, nothing more, is to use seperate >= and < tests:
WHERE MyDate >= '20111101' AND MyDate < '20111201'
Massive thanks Hugo for putting this much more elegantly than I. Sorry to everyone else:blush:
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell