Re: Exclusion list in a query-by-example

Jacob Salomon wrote: > OK, so much for the preliminaries. Now I want query on all states NOT > in that list. i.e. the constructed WHERE clause of the query would be: > WHERE state NOT in ("NY", "NJ", "MN"). I believe what I am looking for > is called an EXCLUSION LIST 4gl is not my strong point, although i have done enough of it. i believe that you can use the CONSTRUCT statement to put your query together based on input from the user, and that could include the elements for your exclusion. i don't have the manuals and such in front of me, so that is as far as i can go. there are much more experienced 4gl people in this group, maybe someone can state if i'm on track and the best way to go about this. mickm