CREATE TABLE table_10966926_2 (position VARCHAR, player_name VARCHAR)

Which position does Colt Brennan play?
SELECT position FROM table_10966926_2 WHERE player_name = "Colt Brennan"
SELECT "position" FROM "table_10966926_2" WHERE "Colt Brennan" = "player_name"