Sorting on a non-numeric field as a numeric

[Concrete]

I have a 12 character string which always starts with two numbers, a period, and then a group of numbers/characters. My question is that I want to sort this field starting with the 4th character/number. Example: 22.102
22.R234
22.1003
22.101

The user wants to see 22.101 before 22.1003

I want to sort this field "numerically" starting after the "." Does anyone know of a formula I could use to accomplish this? Thanks for any help.

 

[rosemaryl]

Dear Concrete,

You could strip the non-numeric characters.

SV's solution for this issue might do it for you with modification:

thread767-438660

HTH,

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.