I'm trying to make a mysql query work in mssql, but my problem is that I can't find any function in mssql that is comparable to the field() function in mysql. I'm using the function as follows...

SELECT Index from table WHERE Index IN (arrayofindices) ORDER BY FIELD(Index, arrayofindices)

any suggestions?

This is how it works in Oracle, you can always try it.

SELECT Index
FROM table
WHERE Index IN (arrayofindices)
ORDER BY Index, arrayofindices;