CREATE TABLE table_1670921_1 (batting_partners VARCHAR, season VARCHAR)

Who are the batting partners for the 1997 season?
SELECT batting_partners FROM table_1670921_1 WHERE season = "1997"
SELECT "batting_partners" FROM "table_1670921_1" WHERE "1997" = "season"