Operating Condition
Syntax: SET SORTCASE ON/OFF
Default: OFF
The SORTCASE setting controls whether sorting should be done with case sensitivity on or off. When SORTCASE is ON, upper case letters appear first in sorting, as per their ASCII value. The following output is returned for the FirstName column values when SORTCASE is ON. Note that "Andy" appears before "amos".
FirstName
------------
Andy
amos
Billy
bob
Chris
carl
The following output is returned for the FirstName column values when SORTCASE is OFF.
FirstName
------------
amos
Andy
Billy
bob
carl
Chris