>Does anyone have a routine to clean up names for mailing?
>
>I have names like 'SMITH E ROBBIE & JONES REBECCA L' would like it to read 'Robbie Smith & Rebecca Jones' or something similar. does anyone have a routine written to clean up names?
>

PROPER() would do a bit of it. The rest would require (as a starting point) a database of probable first and last names :-(