Skip to Content
0
Former Member
Apr 23, 2009 at 12:01 AM

Sorting numbers stored as text

91 Views

Business1 stores ItemCode as an alphanumeric, which makes sense. But we only ever use numbers, so when I try to sort a report by ItemCode, or select a range by ItemCode I get things like this:

4100

41001

4101

4102

42001

42003

42004

4201

Can I get CR to treat these as numbers, and sort/select them as numbers?