title: Fixed array and random numbers in an SQL query
body: <p>What's the easiest way to select one of five fixed strings returned in an SQL Server query, randomly?</p>
  
  <p>I.e. the equivalent of:</p>
  
  <pre><code>function randomColumn() {
     var values = ['apple', 'banana', 'orange', 'cherry', 'lemon'];
     var idx = Math.floor(Math.random() * 5);
     return values[idx];
  }
  </code></pre>
  
  <p>I need to change my existing SQL script to have a certain column return one of these values, without the need to change my client code.</p>
  
  <p>Do I need to create a temp table?</p>
  
  <p>I'm using SQL Server 2008 R2.</p>