1. solution:
Create varchar data type field:
CREATE TABLE Whatever
(
SchoolYear VARCHAR(30)
)
and:
INSERT INTO Whatever (SchoolYear)
VALUES('2011-2012')
2. solution
As Sergey Alexandrovich Kryukov mentioned, to store "
the range of years, should be two numeric field: starting and ending"
CREATE TABLE Whatever
(
StartingYear INT,
EndingYear INT
)
and:
INSERT INTO Whatever (StartingYear, EndingYear)
VALUES(2011, 2012)