>Nice Sergey. There is always a possibility that typos could be in there like for a lastname field:
>
>2illiams ,
>Smith.Holmes (instead of Smith-Holmes)
>Sm1th Jones (this would work fine in the first resolution)
>
>Not sure how to check for typos, guess those will have to be dealt with manually. The goal is to pull all records with more than one word in the field and then figure out how to break it up to where it needs to go into separate fields.
Tracy,
Why not try
User-Defined string functions Transact-SQLDownload #
27115 by Igor Nikiforov.
Igor wrote many of the VFP functions there.
Of course if you must do that in a regular basis, not in the maintenance, I wouldn't use them :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.