Hi All, I've the following query :SELECT ProductID FROM Products WHERE Enabled= ' Yes' AND ProductID IN(varProductID) This query works fine. However the query result is in a different order to what I passed in varProductID. How can I order the results based on my list like varProductID = "1000,2500,1500" At the moment the result is 1000 1500 2500 But I want 1000 2500 1500 Thanks, Neil _________________________________________________________________
Discover and Win with Live Search http://clk.atdmt.com/UKM/go/msnnkmgl0010000007ukm/direct/01/