SET CASE sets the uppercase or lowercase distinction when a comparison is used with WHERE clauses, IF structures, WHILE loops, the TALLY command, and in the RULES command where comparisons are equal or not equal. R:BASE stores the setting with the database. If CASE is set off, both uppercase and lowercase text are displayed for a comparison regardless of how you enter the text. For example, if you enter "case", you could find "Case" and "CASE" with CASE OFF.

Which letters are "Upper Case" and which letters are "Lower Case" is determined by the various Case, Collating, and Folding tables as stored in the Database. You can change the stored table by altering the RBASE.CFG and using the RELOAD WITH USER CASE command or the PACK WITH USER CASE command.