Order Problem

[Neil Tompkins]

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/