>>If it returns .f. you will need to parse your field and get rid of the imbedded characters
>>
>>To parse try something like
>>
>>STORE UPPER(ALLTRIM(FIELD)) TO mTEST
>>STORE SPACE(0) TO mFieldString
>>FOR i=1 TO len(mTEST)
>> *TEST FOR A-Z
>> IF BETWEEN(ASC(SUBSTR(mTEST,i,1)),65,90)
>> STORE mFieldString + SUBSTR(mTEST,i,1) TO mFieldString
>> ENDIF
>>ENDFOR
>>
>>REPL Field WITH mFieldString
>
>thanks for the code... I need to strip out all characters, not just a through z.
>How would I do this?
>thanks again.. rob
the code above strips everything but A - Z. you might need to include the lowercase letters, but this
IS what you were looking for...