Table schema:
CREATE TABLE table_name_54 (player VARCHAR, span VARCHAR)

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