>Second returning EOF suggests custid is type char.
>What does this return ?
>rs=oConnection.Execute("select * from c:\gmgwin\main\arypat01.dbf where ltrim(custid)=='" + "765583'")
>PS: Assuming customer with id 765583 really exists.
>Cetin
Or:
rs=oConnection.Execute("select * from c:\gmgwin\main\arypat01.dbf where val(custid)=" + "765583")
Cetin