Is there a way to do a record selection based upon a comma delimited set of values? Say I have 3 ID's I want to get a result set from, which is contained in a particular column/variable:

123,214,282

Now I would like to do a selection like:

{table.column} contains (123,214,282)

Any ideas?

I'm not sure about delimited sets, but maybe you could construct an array using the fact that it's comma-delimited and then use {table.column} in [ your array ]

Edited by Keikoku - 11 Jan 2011 at 8:26am