Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > S > SET

SORTCASE

Scroll Prev Top Next More

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