title: TSQL - Is it possible to define the sort order?
body: <p>Is it possible to define a sort order for the returned results?</p>
  
  <p>I would like the sort order to be 'orange' 'apple' 'strawberry' not ascending or descending.</p>
  
  <p>I know ORDER BY can do ASC or DESC but is there a DEFINED('orange', 'apple', 'strawberry') type thing?</p>
  
  <p>This will be running on SQL Server 2000.</p>