REPLACEING THE "DEAR" FIELD WITH THE LAST NAME FROM CONTACT FIELD
    -----------------------------------------------------------------
  
     If a database contains doctors/dentists as customers, you
may want to place the last name from the CONTACT field to the
DEAR field.  For example: 
 
     Dr. Robert Jones 
     Dr. Roberta Williams 
 
     Before performing Group Replaces, it is always a good idea
to have a current backup of your data in the event that something
goes wrong.  You may want to set up a filter based on one record
to test the Group Replace before changing a group of records. 
 
To perform the Group Replace, from the TeleMagic Main Menu Touch: 
 
1.  "O" for Other Options 

2.  "D" for Database Utilities,  
 
3.  "R" for Replace in Filtered records 
 
4.   In the "Replace this Field" enter the Dear field (US5 or the
     appropriate field in your database) by pressing F-2 to bring
     up the  Fields List Box.  Highlight the Dear field and press
     <ENTER>.

5.   At the "To look like this" enter the following command: 
 
               &right(con,(30-rat(" ",trim(con)))) 
 
6.   Select "Screen" when prompted. 
 
     After TeleMagic has finished the Replace, go to the filtered
record and verify that the Replace was successful! 
 
100991CLW 
Indexed under R  Rat Command to grab Last Name from the CON Field