xxxxxxxxxx
declare @Existingdate datetime
Set @Existingdate=GETDATE()
Print @Existingdate
xxxxxxxxxx
# in November of ANY year
SELECT * FROM table WHERE purchase_period LIKE '%-11';
# in whole 2012
SELECT * FROM table WHERE purchase_period LIKE '2012-%';
# in December 2012
SELECT * FROM table WHERE purchase_period LIKE '2012-12';