CREATE TABLE table_name_54 (player VARCHAR, span VARCHAR)

What player has a span of 1997-2009?
SELECT player FROM table_name_54 WHERE span = "1997-2009"
SELECT "player" FROM "table_name_54" WHERE "1997-2009" = "span"