I have a column that is data type varchar(6).
The column contains data like YYYYMM. Example 201610 for October2016.
I would like to be able to handle the data in this column like if it was a date without the days, so I could do a query like:
Where InvoiceDate > '201601'