Operator 'in' in a select statement

Hi,

I don't know how the operator 'IN' work retrieving columns in a select statement . For example in the following select :

        SELECT col1 FROM table1 WHERE col1 IN (10,20,15,30)

columns are displayed

	col1
            --------
	   30
	   15 
	   20
	   10

order is different to the order I write in the select statement . How I can do if I want to retrieve columns in the order I write them ?

Thanks ,

        Stefano Compieta . Received on Sat May 25 1996 - 00:00:00 CEST