Follow up to this question: CAML is ordering by content type even though not specified
I have the following query:
<Where>
<And>
<Or>
<Eq>
<FieldRef Name='_ModerationStatus' />
<Value Type='ModStat'>0</Value>
</Eq>
<BeginsWith>
<FieldRef Name='ContentTypeId' />
<Value Type='ContentTypeId'>0x0120</Value>
</BeginsWith>
</Or>
<And>
<Geq>
<FieldRef Name='Number' />
<Value Type='Lookup'>0</Value>
</Geq>
<Neq>
<FieldRef Name='ID' />
<Value Type='Counter'>0</Value>
</Neq>
</And>
</And>
</Where>
<OrderBy>
<FieldRef Name='NumberOf' LookupId='True' />
</OrderBy>
<GroupBy Collapse='True'>
<FieldRef Name='NumberOf' />
</GroupBy>
It works well, however not every list item has a value for the column 'NumberOf', so when my results are returned, with the numbers grouped at the bottom of the results, like this:
Is it possible to have the opposite, where the ordered 'NumberOf' column with numbers are first (ie. 2,3,5) and null values afterwards?