Alphabetical.. somewhat

[JasonMcD (Jason McDermott)]

I mean, it is odd, but if it takes a while to figure out why, maybe do a row_number() as the sort?

Number Rows in BAQ

row_number() over (partition by table.field, table.field etc order by table.field asc) You use the groupings if for what you want to group by (you might be able to skip that if you literally only want row numbers) and order by is what the numbering uses to order by. You can also add asc or dec for which way you want the order to go by.

Also, unrelated and to get on @ckrusen ‘s nerves, when did Windows’ sort function become so stupid?

MRP2 gets wedged between MRP-001 and MRP-002, etc. They try too hard sometimes.