Why does MinString sorts different to the sorting by text in listboxes?

[veidlburkhard]

I used MinString($Field) to give me the first field of my selection, but was surprised to get the number three in the ranking of my selection in the example shown below: (all other selections not selecting BLZ gave me the right result !?!)

[Anonymous]

you have to put it in the expression to take effect.

Cheers,

E

[swuehl · Accepted solution]

Minstring() seems to handle / sort capital letters in the middle of the string different from the text sort option.

This just adds to the general confusion of sorting, IMHO, e.g. when sorting numerical parts in a string.

A

=MinString(Capitalize($Field))

should get the fist value of your list box values, but that's not a stable solution, I think.

[veidlburkhard]

Thank you swuehl. This works fine: