<p>I want to write a query like this:</p>

<pre><code>SELECT o.OrderId, MAX(o.NegotiatedPrice, o.SuggestedPrice)
FROM Order o
</code></pre>

<p>But this isn't how the <code>MAX</code> function works, right?  It is an aggregate function so it expects a single parameter and then returns the MAX of all rows.   </p>

<p>Does anyone know how to do it my way?</p>

I don't think so. I wanted this the other day. The closest I got was:
```
```
SELECT
  o.OrderId,
  CASE WHEN o.NegotiatedPrice > o.SuggestedPrice THEN o.NegotiatedPrice 
     ELSE o.SuggestedPrice
  END
FROM Order o
```
```