CREATE TABLE table_204_342 (id NUMBER, "#" NUMBER, "player" CLOB, "span" CLOB, "caps" NUMBER, "total caps" NUMBER, "win %" CLOB)

only player to serve as captain from 1998-2007
SELECT "player" FROM table_204_342 WHERE "span" = '1998-2007'
SELECT "player" FROM "table_204_342" WHERE "span" = '1998-2007'