title: "Order By" using a parameter for the column name
body: <p>We would like to use a parameter in the "Order By" clause of a query or stored procedure created with the Visual Studio DataSet Designer.</p>
  
  <p>Example:</p>
  
  <pre><code>  FROM TableName
   WHERE (Forename LIKE '%' + @SearchValue + '%') OR
         (Surname LIKE '%' + @SearchValue + '%') OR
         (@SearchValue = 'ALL')
  ORDER BY @OrderByColumn
  </code></pre>
  
  <p>This error is displayed:</p>
  
  <pre><code>Variables are only allowed when ordering by an expression referencing 
  a column name.
  </code></pre>