Sort by Expression

[#1]

Hi,

I have a list-box with some text values from the database. I am using an expression = Capitalize (Field) to get the correct format.

Now, when I go to Sort->Expression and Paste the same expression as above and put it to Ascending, I am not getting the Field sorted based on Alphabetical order. How can that be achieved?

[kaushiknsolanki]

Hi,

     What is the order which it is showing, will you please share the example of what is expected and what it is showing.

Regards,

Kaushik Solanki

[#3]

Properties . sort > check "A-Z"   & uncheck expression

otherwise check load order "Original"

[swuehl · Accepted solution]

Try correcting your correct format in the script

LOAD     

     Capitalize(FIELD) as FIELD,

....

then use alphabetical sort order in your list box.

[#5]

Thank you swuehl..that worked well...