I'm a bit confused. Are you sure that RENDORIND is a character field. If so, were the values in it before the SELECT '0000000000'. My guess is that in some way you are changing the field type from numeric (where the value was zero) to character where the value is spaces (empty). If you listed the tables structure(s) and SQL code it would help.

>Hi,
>
>I have a select statement in my program, in which one of the fields that gets selected is a field called RENDORIND (CHAR(10)). The name of the table that this select statment generates in TmpClaim.dbf. All the values for the RENDORIND field at this point are 0's.
>
>I append the contents of this TmpClaim file to a Process.dbf, and all the RENDORIND records are blank. No 0's. The size of the fields are the same (CHAR(10)) and the spelling of both field name are exactly the same. Any idea's??????
>
>Thanks,
>
>Jolene