Mike Matthews - Omnis omnis at
Mon Dec 28 15:52:17 EST 2020

Hello Martin,

If you make L_Name as a National type.  This will then sort it by AaBbCcDd etc.

Mike Matthews

Lineal Software Solutions
Commercial House, The Strand<x-apple-data-detectors://1/1> Barnstaple, Devon, EX31 1EU<x-apple-data-detectors://1/1>

omnis at<mailto:mike.matthews at><><>

On 28 Dec 2020, at 15:39, Martin Luce via omnisdev-en <omnisdev-en at<mailto:omnisdev-en at>> wrote:


I am trying to sort a list alphabetically but not divided between upper and lower case. ie I want a word starting with lower case c to be in the right place amongst all the Cs and not to have the lower case starting letters appearing after all the upper case first letters.

I am using

Do i_InPortLst.$sort($ref.[L_Name])       L_Name being the name of the column to sort on in the list

Have tried

Do i_InPortLst.$sort($ref.[L_Name],upp())
but does not help

Here is to a better New Year for all

Manage your list subscriptions at
Start a new message -> mailto:omnisdev-en at

More information about the omnisdev-en mailing list