i've a little prob with SQL .. im not familiar with SQL so im not sure whether it can be done ...

i've values = 2,4,5,7,8 .. the SQL query shud search for all these values and return records corresponding to each value . how i do this .

SELECT *
FROM myTable
WHERE myField IN (2,4,5,7,8)

might do it for you.