CREATE TABLE table_name_98 (player VARCHAR2, pick__number VARCHAR2)

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"