Tidying data for mailings

By Neil Shorney, Director, Naturally Sales Ltd.



When we have an untidy data last for postal mailings, it can really affect the customer's 
perception of us as a company: missing capitals, too many capitals or poorly laid-out addresses can all make mailing labels look untidy. At the beginning of September, we looked at the TRIM function to remove erroneous spaces from words. Today we will look at three functions to correct the case of letters:

    UPPER(ref) - this will change all characters to upper case
    LOWER(ref) - this will change all characters to lower case
    PROPER(ref) - capitalises the first character of each word

Using a combination of these functions, we can tidy our data for professional-looking mailings.