CREATE TABLE table_204_342 (id DECIMAL, "#" DECIMAL, "player" TEXT, "span" TEXT, "caps" DECIMAL, "total caps" DECIMAL, "win %" TEXT)

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'