CREATE TABLE table_74497 ("Pick #" FLOAT, "MLS team" CLOB, "Player" CLOB, "Position" CLOB, "Affiliation" CLOB)

What is the position of the Colorado Rapids team?
SELECT "Position" FROM table_74497 WHERE "MLS team" = 'colorado rapids'
SELECT "Position" FROM "table_74497" WHERE "MLS team" = 'colorado rapids'