In this case should the suggestion from tresesco work if you removed the additionally spaces within ' - '. In general it's better to use always real dates in a pure numeric format for all matching and calculations. It enabled for example to compare such YearMonth field with >= or <= which isn't possible with a string like in your sql. Often it is helpful to use a master-calendar for this: How to use - Master-Calendar and Date-Values.
