title: in sqlserver, need to select one of two columns, can a case statment do this?
body: <p>My table:</p>
  
  <p>Users (userID, col1, col2)</p>
  
  <p>I want to make a generic stored procedure, but I need to return EITHER col1 or col2 in a query.</p>
  
  <p>Can I case statement handle this situation?</p>
  
  <p>SELECT userID, col1
  FROM Users</p>
  
  <p>OR</p>
  
  <p>SELECT userID, col2
  FROM Users</p>