Well, over at one of my favorite forums, Tek-Tips, I was watching a particular thread related to getting the month and year from a particular date. You have to read the whole thing, as the original poster’s issue was quite easy with a bit more SQL background, but the answer supplied by gmmastros – who is pretty much the closest thing to a SQL god I know – was something I would never have thought of. His answer was:
Select Month(GetDate()) * 100 + Year(GetDate()) % 100
Make sure you head on over to the specific thread to read the whole thing.