Can a string be sorted numerically?

[rleiman]

Hi Everyone,

1 of my columns in a browse is a string column. The column can have values such as ABC, 004, 0453, 100. Can I sort the column so that the numbers will be first followed by the non-numbers. "Enable Sort Header" is turned on.

Can I sort it so the values are like this?
004
100
0453
ABC

Thanks,
Emad

 

[ShankarJ]

Hi Emad,

If you use a fixed width value in the column i.e. 0004, 0100
0453, ABC there will be some organization in sorting. Otherwise it will follow the normal ASCII sorting.

Regards