CREATE TABLE table_name_98 (player VARCHAR, pick__number VARCHAR)

Which player was Pick #40?
SELECT player FROM table_name_98 WHERE pick__number = "40"
SELECT "player" FROM "table_name_98" WHERE "40" = "pick__number"