My field can contain both numbers and strings (like A1, B2, C3). I can't easily change this.
I was using Order By on this field, but of course if numbers then 11 comes before 2 etc. Using Val fixes that but mucks up the alphanumeric ones.
Possibly I could check the field first, then use the order by depending on whether Strings or Numbers (There is never both). But is there a better way ?