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

how long did michel crauste serve as captain ?
SELECT "span" FROM table_204_342 WHERE "player" = 'michel crauste'
SELECT "span" FROM "table_204_342" WHERE "player" = 'michel crauste'