I need to know more about how you plan to keep track of what options have been selected. Are you updating any permnanent table with this information? Since you indicated a "user" having selected options, can I presume this is a web-based order process? From the code you provided, I can't see a clear picture of where the already selected options are being kept, so until we know where this information resides, it would be impractical to try and write a query.

Also, a table variable you declare in a query goes away when that query is complete, and does not hang around for re-use in a subsequent call to that query code, so perhaps you need to make that something mroe permanent? (e.g., an array variable in your asp page).

Steve

(aka smunson)

:):):)