I have a table that has unique id, c_id and an integer number indicating it's ranking (this number is updated). The higher the number (c_count) the higher it's ranking.<BR><BR>What I need to do is grab ONLY the top ten items, then compare these results against an id number that I want to check if it is in the 'top ten'. I could do a simple sql and then check it in asp, but I would like to do a more complex sql that handles all of this. I can't seem to get the syntax correct though; I have a feeling it should be something like;<BR><BR>SELECT * WHERE C_ID=<supplied number> <BR>AND C_ID IN <BR> (SELECT ...get top ten in here...)<BR><BR>Can anyone help me out here?<BR><BR>Thanks!!