Sorting Problems...

[stormtrooper]

Hi. I have a number field in DB2 that has been converted from data type NUMBER to data type VARCHAR. Now when I do a sort ascending in CR7, it doesn't sort properly. I know that the problem is that it searches the first character and does a sort on that.

eg.) 1000 will come before 999 or 990 or 99, etc.

How could I get around this?

Thanks

 

[mbarron]

Create a formula:

tonumber({field})

then sort on the formula field. Mike

 

[stormtrooper]

Thanks Mike. I just got it also!