HOW TO CHANGE DATA IN THE CONTACT FIELD TO LOWER CASE
	-----------------------------------------------------

     If you imported a group of records and the names are all in upper case¨
in the CON Field, you can use the following dBase command in a Group¨
Replace to change the data to lower case.  The following Replace can also¨
be used for other fields that contain two words by substituting the field¨
name in the Replace expression.

NOTE:  	You may want to set up a filter for one record only and try the ¨
	Group Replace before replacing data for all your TeleMagic ¨
	records.  It is also a good idea to have a current backup before
	performing advanced Group Replaces such as this one.

	From the TeleMagic Main Menu:

	1.  Select "0" for Other Options
	2.  "D" for Database Utilities
	3.  "R" for Replace in Filtered Records
	4.  Enter "CON" at the 'Change this Database Field' prompt
	5.  Enter the following string at the "To look like this" prompt.

	    NOTE:  The following string is to be entered on one line:

&upper(left(con,1))+lower(subs(con,2,at(" ",con)-1))+upper(subs(con
,at(" ",con)+1,1))+lower(subs(con,at(" ",con)+2))

   * This Group Replace will have the effect of changing JOHN DOE or john¨
doe to "John Doe."

(end DRM545)
indexed on: import, names, replace