Pervasive 11 order by query
Posted on 2014-02-24
Using Pervasive 11, I wish to order by "category".
I wish that the category MAT is listed first, followed by LAB, OTH, MSC and then all the rest. All the rest will be numbers.
So, category looks like MAT, LAB, OTH, MSC, 112, 700, 430, etc.
Tried, with no luck, using a case statement.