SQL Server 2008 Rank with Nulls last
<p>I have the below extract from a long query that I wrote. I'm trying to create a Rank function to rank so I then can filter with a sub query</p>

<p>How would one utilize rank where blanks and null would be ranked last?</p>

<p>Rank </p>

<pre><code>id    Category        Review
 1      Site           "null value"
 1     "blank value"      Yes
 1     Sited            Yes
</code></pre>

<p>Expected Output:</p>

<pre><code>id    Category        Review            Rnk
 1      Site           "null value"       3
 1     "blank value"      Yes             2
 1     Sited            Yes               1
</code></pre>