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&&works
>>	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