I have a report I'm trying to sort by a certain field. This field generally consists of numbers only, two digits max.
I have it sorted, ascending. Here is what I get:
1
10
11
12
13
14
2
3
4
4a
4b
5
6
7
8
9
No I would just convert that field to a numerical value, but as you can see it may contain letters. Any ideas?