Sort Numbers as Numeric

Michael Mantkowski michaelj at clientrax.com
Sat Jun 12 11:18:26 UTC 2021


I have a list of values in a character field like this.

A1
2
1
B2
20
12

It Sorts like this.

1
12
2
20
A1
B2

I want it to sort like this.

1
2
12
20
A1
B2

Seems like I should know how to do this, but it is not coming to me this morning...

Any help?

Thanks!!

*********************************************************************
Michael Mantkowski
ClienTrax Software
1-614-875-2245
*********************************************************************

 



More information about the omnisdev-en mailing list