>This goes into an endless loop for me. It is not stripping out the period so it just keeps looping.
>
>
>tcName = 'Amerson, Jr., Harry L'
>
>* Strip periods
>DO WHILE AT('.',tcName) > 0
> CHRTRAN(tcName,'.','')
>ENDDO
>
>
>Oh, and I didn't look at the help, but the intellisense was pretty clear on the syntax. I may have missed something though. Sorry if I did, but I would really like some help here. Or maybe some suggestions on a better way to do it.
It will, because you didn't store the value of the CHRTRAN()
DO WHILE AT('.',tcName) > 0
tcName = CHRTRAN(tcName,'.','')
ENDDO
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.