Once again,

You have saved me. Thank you ever so much.

Regards,
Neil

>Guess what :) You'd succeed if you chose someone else other than 765583.
>
>select * from c:\temp\neil\arypat01.dbf where ltrim(custid) = '765583'
>select * from c:\temp\neil\arypat01.dbf where ltrim(custid) == '765583'
>select * from c:\temp\neil\arypat01.dbf where val(custid) = 765583
>select * from c:\temp\neil\arypat01.dbf where custid like '%765583%'
>
>all succeeded vs custid = '765583' failing (char (6)). I was stumped at first too :)
>select * from c:\temp\neil\arypat01.dbf where custid = '7'
>returned all but 765583.
>
>Checked your table and you had 2 indexes usign custid in key. All above expressions are nonoptimizable and are not using any available indexes :) I went to fox2x, reindexed the table and now all works including :
>
>select * from c:\temp\neil\arypat01.dbf where custid = '765583'
>select * from c:\temp\neil\arypat01.dbf where custid == '765583'
>
>Cetin
>
>
>>I sent the tabel to cetin@yapayzeka.com
>>
>>>>CHARACTER
>>>>
>>>>>Neil,
>>>>>In your free table what's the datatype of custid ?
>>>>>Cetin
>>>
>>>Would you email me the free table :)
>>>Cetin