On Tue, 17 Jul 2001, Scott Muir wrote:
> Thank you... Your suggestion is how I am doing it until a better suggestion
> comes along, but without building a dynamic sql statement with many UNION
> statements (read: mess), I can't think of how to build a non-table-driven
> multi-row query result...
depending on the number of values you would like to compare, you can use
something like
select value from foo where value in (1,2,3,4,5)
have fun,
helge