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 . 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