>You mean with the IN() clause. Ussually what I do is to put all the keys in a temp table and perform a join with it. Its possible to convert a comma delimited list passed as a parameter into a temp table. Eg

Yes, this is what I am doing now but only if I have a certain number of keys. The IN clause would provide a better and cleaner approach up to a certain number.