Thanks Boris! :o)
>>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 :-)
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
