Hi - can I ask for a scenario for when this would be useful? I'm keen to learn.

As I see it, if I wanted a list of values - the context I would use it in, wouls be a select statement - so why not just do this:

Select myID, myField from myTable where myDesc in (Select Descriptions from DescTable)

Thanks for any clarification.

Mark