Hi Friends,

I have one query using "IN" clause for example,

select empcode from Employee where EmpCode in ('1006','1001','1005')

In this I am getting results in the order of EmpCode 1001,1005,1006 that is order in the database...

but i want the result in the order of the values in IN clause... that is

1006,1001,1005

how to do that...

please help me...

thanks and Regards,
P.Nagarajan