add "ALL" to a dynamic LOV?
I want to add "ALL" to a dynamic LOV for users to select all values. I know I can do it by using some SQL SELECT command such as SELECT NAME='ALL' UNION NAME FROM TABLE.
But what should I do to ensure ALL is always up on the top of the LOV? In CR, LOV is alwasy sorted ascendently or descendent so I will have to go and search in the list when I want to select 'ALL'. If 'ALL' cannot be the first in a sorted list, can I at least make 'ALL' as default in a dynamic LOV? Thanks.