CREATE TABLE table_31997 ("Year" FLOAT, "Competition" TEXT, "Date" TEXT, "Location" TEXT, "Score" TEXT, "Result" TEXT)

Tell me the result for harrogate
SELECT "Result" FROM table_31997 WHERE "Location" = 'harrogate'
SELECT "Result" FROM "table_31997" WHERE "Location" = 'harrogate'