SQL Query returns Invalid Sequence

Question

Hi I am Using Simple Query with IN Operator. I am using following Query

SELECT CustID  FROM Customer WHERE CustID in (6,34,5,4,3,2,1)

Now it displays Following Order

custId  
1   
2   
3   
4   
5   
6   
34

But I want the result as the same sequence which I pass in the IN Clause.

Answer 1

SELECT CustID  FROM Customer WHERE CustID in (6,34,5,4,3,2,1)
ORDER BY  CASE WHEN CustId = 34
               THEN 5.5
               ELSE CustId
          END DESC

Answer 2

Try this Query Ramdas......

SELECT CustID  FROM Customer WHERE CustID in (6,34,5,4,3,2,1) 
ORDER BY CHARINDEX(','+CAST(CustID as varchar(MAX))+',', ',6,34,5,4,3,2,1,')