| # To specify a range Default value The default values of the From and To fields include every available record. Latin characters (ASCII or ISO 8859 character set) The From field contains spaces to indicate the first available record. The default value of the To field varies depending on the type of field. The To field can contain: One or more Zs (in an alphanumeric field). One or more 9s (in a numeric field). Other values. Other Character sets If you use non-Latin characters (for example, Hebrew or Greek), you may need to modify default characters in these fields to ensure that all values are included. This is especially likely if you use multibyte character-sets (for example, Japanese or Korean). You can alter these values in the Minimum Form Value field and Maximum Form Value field in the Locale Data (tttss0104s000) session. Alphanumeric fields In alphabetic order, uppercase precedes lowercase. Uppercase Zs indicate the highest value of a field that can only contain uppercase characters. For example, LN converts record codes to uppercase. Lowercase Zs indicate the highest value of a field that can contain both uppercase and lowercase characters. Dates The highest value for a range of dates depends on how the range is used. The highest value is either: Today's date Today's date + 40 years List values If you specify all the possible values of a list, for example, the range of possible types of an element, the From and To fields can have values such as: Monday - Saturday. Planned - Closed (for an Order status). The default list values in the From and To fields are not the alphabetically first and last values. However, if you do not change the default values, the range includes all possible values of the list. Text numbers The highest possible number of a text is 2147483647. Text numbers are used, for example, in the Print Texts (tttxt1400m000) session. |