Sorting based on first digit only

[#1]

I have numbers that need to be sorted as follows:
0

001

1
10
1000
2
20

202AC
2000X
etc.

I have tried everything I know,

still i am getting following results

0

1

2

10

20

etc

any suggestions?
Thanks,

[#2]

Hi Dilyana,

I have tried this option also[=text(YourFieldName) ] but it is sorting based on text first. I want it to be sorted first by numbers then by text.

Please find an attachment in my earlier post, also at the end i have mentioned the desired result for the column "stat".

Please suggest if u found something useful.............

Thanks!

[#3]

this page intentionally left blank

[#4]

Hi Anders,

I got the exact result! Thanks a lot :-)!

Please explain me how this function works?

[#5]

Hi Dilyana,

i didn't get it at the first place what u asked but that opton works!

Thanks a lot!

Regards,

Amey.

[#6]

Hi

I use expression in listbox with =text(stat)

then sort by text.

Regards

Anders

[#7]

Thanks man!

Regards,

Amey.