C5_UPPER

 UPPER()
 Convert lowercase characters to uppercase
------------------------------------------------------------------------------
 Syntax

     UPPER(<cString>) --> cUpperString

 Arguments

     <cString> is the character string to be converted.

 Returns

     UPPER() returns a copy of <cString> with all alphabetical characters
     converted to uppercase.  All other characters remain the same as in the
     original string.

 Description

     UPPER() is a character function that converts lowercase and mixed case
     strings to uppercase.  It is related to LOWER() which converts uppercase
     and mixed case strings to lowercase.  UPPER() is related to the
     ISUPPER() and ISLOWER() functions which determine whether a string
     begins with an uppercase or lowercase letter.

     UPPER() is generally used to format character strings for display
     purposes.  It can, however, be used to normalize strings for case-
     independent comparison or INDEXing purposes.

 Examples

     .  These examples illustrate the effects of UPPER():

        ? UPPER("a string")           // Result: A STRING
        ? UPPER("123 char = <>")      // Result: 123 CHAR = <>

     .  This example uses UPPER() as part of a case-independent
        condition:

        USE Customer INDEX CustName NEW
        LIST CustName FOR "KATE" $ UPPER(Customer)

     .  UPPER() is also useful for creating case-independent index key
        expressions:

        USE Customer NEW
        INDEX ON UPPER(Last) TO CustLast

     .  Later, use the same expression to look up Customers:

        MEMVAR->Last = SPACE(15)
        @ 10, 10 GET MEMVAR->Last
        READ

        SEEK UPPER(MEMVAR->Last)

 Files   Library is CLIPPER.LIB.

 

One response to “C5_UPPER

  1. Pingback: C5_Data Manipulation | Viva Clipper !

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.