How can I lookup a list of values in SQL?

The question is not what I would like to return. The question is how to lookup a long list or in other words, how can I join the SQL table of the server with the long list of values I want to look up, if I cannot write anything on the server.