CREATE TABLE table_17120964_9 (competition VARCHAR, opponent VARCHAR)

what was the competitoin where the opponent is sheffield scimitars?
SELECT competition FROM table_17120964_9 WHERE opponent = "Sheffield Scimitars"
SELECT "competition" FROM "table_17120964_9" WHERE "Sheffield Scimitars" = "opponent"