What was the result when Dundee were the Opponent at Venue A on 6 September 1986?
CREATE TABLE table_name_9 (result VARCHAR, date VARCHAR, opponent VARCHAR, venue VARCHAR)
SELECT result FROM table_name_9 WHERE opponent = "dundee" AND venue = "a" AND date = "6 september 1986"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_9 (result VARCHAR, date VARCHAR, opponent VARCHAR, venue VARCHAR) Question: What was the result when Dundee were the Opponent at Venue A on 6 September 1986? [/INST] SELECT result FROM table_name_9 WHERE opponent = "dundee" AND venue = "a" AND date = "6 september 1986" </s>