I have a Query with a long list of values (hundreds). I need to have the values returned in the order they are entered into the query,if possible. For example: SELECT column FROM Table Where In (Value1,Value2,Value3,Value4,Value5) I would like for the return values to be displayed in the order they are listed in the query. The standard Order By Column will not work because the values are returned in alphabetical order, in this case I need them to be returned as listed in the query. Can this be done? If so can you show me how. Thanks.
SELECT WHERE IN ('value1, 'value2') sort
Posted - 05/14/2012 : 14:30:25
