Several options.

1) Create an inlist(), and then use macro expansion to execute your command. Limited in the number of options, since you can have something like 24 parameters (?) as a maximum.

2) Create your list in a string, for example: ',CAMP,JUV,ADULT,' The additional comma at the beginning and at the end is on purpose. Query:

Select... where "," + alltrim(KeyField) + "," $ MyList

This might be slow for very long lists. In any case, all records have to be analyzed; this is not Rushmore Optimizable.

3) Create a table or cursor with the allowed values.

select * from TargetTable;
  where KeyField in (select KeyField from AllowedValues)

This should relatively quickly, and with hardly any limitations, both for long lists, and for a large table.

>I have a listbox where a user selects multiple items. I am building a list with selected items and then I want to use that list to extract values from a table. The list can vary depending on how many thing the user selects from list box. How can I write a query based on items from the list.
>
>for example I have a list built using commas
>
>

>*lcList contains items selected from listbox
>*lcList contains values like 'CAMP,JUV,ADULT' etc.
>

>
>how do I write a query that selects units that contain values from lcList?
>
>for example:
>
>

select * from vehicle where v_unit = the lcList

>
>I can write
>
>select * from vehicle where v_unit = 'CAMP' or v_unit = 'JUV' or v_unit = 'ADULT'
>
>
>but my list can vary depending on items selected from list box and I don't how to write a query where v_unit can be dynamically used.
>
>thanks
>Nick