Check cpconvert() in help.
>hi,
>
>sorry , field(WND_CHRS) have Arabic characters at another table
>
>just i need any example or way to
>replace (any fields is characters type) WITH NEWNAME&&&
>
>thanks
>>If I understand your question correctly, you can use transform() which will convert any value, both fields, variables and properties, into a character string.
>>
>>>hi all,
>>>is there away to convert any fields at my table have characters type,
>>>
>>>without determine the fields that need to convert as.
>>>
>>>PUBLIC newname
>>>
>>>close database
>>>USE CNV_WORD IN A ORDER 2
>>>
>>>USE code99 IN C
>>>
>>>SELECT C
>>>NEW_WORK = SPACE(1)
>>>IND_1 = 1
>>>DO WHILE .NOT. EOF()
>>>
>>> OLD_NAME = cname
>>> do cnv_work
>>>* REPLACE cname WITH NEWNAME
>>> replace (any fields is characters type) WITH NEWNAME
>>> IF .NOT. EOF()
>>> SKIP
>>> ENDIF
>>>ENDDO
>>>brow
>>>
>>>procedure cnv_work
>>> SELECT A
>>> wrk_leng = len(alltrim(old_name))+1
>>> DO WHILE IND_1 < wrk_leng
>>> WRK_CHRS = SUBSTR(OLD_NAME,IND_1,1)
>>> SEEK WRK_CHRS
>>> IF FOUND()
>>> NEW_WORK = NEW_WORK + WND_CHRS
>>> ELSE
>>> NEW_WORK = NEW_WORK + WRK_CHRS
>>> ENDIF
>>> IND_1 = IND_1 + 1
>>> ENDDO
>>> NEWNAME = NEW_WORK
>>> NEW_WORK = SPACE(1)
>>> IND_1 = 1
>>> select c
>>>return
>>>
>>>
>>>thanks