Sorting column in both way in Lotus Notes.

Question

I have a Main field which consist the value of 10 other fields for each document , when I tried to sort this field value in the view column using the column sorting properties I didn't get the desired result.

Here is the example how value is displaying - 10.other 10.other 1c.NSR 10.others 1c.NSR 2b.First in Fab 10.other 10.other

it should display like.

10.other 10.other 10.other 10.other 10.other 1c.NSR 1c.NSR 2b.First in Fab

Any suggestion will be appreciable...... Rupesh