CAPS


The CAPS ON or OFF command controls whether characters entered in lowercase format are automatically set to uppercase when in an edit session.

You can execute the CAPS command during a browse or edit session. You can also set this option through Option 0, Defaults and User Parms (see Browse-Edit-SQL-Analysis-Display-Options) or through the PROFILE primary command (see PROFILE-PRO).

Important

The CAPS option has no effect on the OBJECT NAMES UPPERCASE option set through the PROFILE parameters window. See Profile Parameters Window.

Since CAPS is a profile option, its status remains in effect until you change it.

image2021-3-9_15-1-25.png

ON

All text of the column field that you enter, insert, or change, is converted to uppercase format. The conversion occurs when you press Enter, issue an END command, or issue a SAVE command. The conversion affects all text in a modified field up to the end of the current line of the field. For example, you change the letter u to i in the following 20 character column with WRAP 10 in effect, and all 10 letters in the changed line of the column are capitalized.

Before

After

ROW ID: 9
 ----+---10
 000005 Thus is an
 392 ----+---20
 example.

ROW ID: 9
 ----+---10
 000005 THIS IS AN 18 ----+---20
 example.

OFF

All characters are accepted in the same case in which they were entered. No lowercase to uppercase conversion occurs.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*