Find or Search in a query!

Maybe this the wrong area but here goes. I have SQL2000 and database. I need to write a query(or something) (again, I am new at this), to type in approx 50 names(last,first),run it and “find” if they are in database X, and return the results, Not found section , found section. In the found section, I can insert more select statements to bring up all the data I can find on each of the found persons. I will be doing this process once a week.