long "IN" list, tempo in-memory table

Hi,

    I want to do a SQL query but dont know how to, please help!

    What i'd like to do is a query like this:

    SELECT *
    FROM mytable
    WHERE
        myvalue IN (v1,v2,v3,......);

    The problem is that in ther "IN" list, one can not give more than     256 values. But I need absolutely specify more than 256 values.

    Can I create an in-momory temporary table then use it? If yes how to?

    If no, is there other *efficient* ways to have the query done?

Thanks a lot!

Fei Received on Sat Jul 24 1999 - 12:57:17 CDT