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 towhat 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/msnnkmgl...ukm/direct/01/