Expand|Select|Wrap|Line Numbers
- SELECT "<All>" as CCenter, 0 as BranchID, 1 AS SortOrder FROM TblBranch
- UNION SELECT CCenter , BranchID, 2 AS SortOrder
- FROM TblBranch
- WHERE (((Nz([CCenter]))<>0))
- ORDER BY SortOrder, CCenter;
Here are the first few results. As you see the 100 is the first (text value). It should be the last value
Expand|Select|Wrap|Line Numbers
- CCenter BranchID SortOrder
- <All> 0 1
- 100 9 2
- 63 26 2
- 69 27 2
- 70 6 2
- 72 19 2
- 74 11 2
- 75 12 2
If I replace the <All> with 0 it works as expected
How do I get over this?
Thanks
Phil