>I have a weird situation here. I have a table being used by a FoxDos2.6 application. The file is on a Novell server on our LAN. A couple weeks ago the server crashed and locked which damaged the file. This file was repaired with foxfix and the damaged section of records removed. Then it was packed and reindexed.
>
>There are 1250 records that have a "Y" in a character field called Active. If I do a select for active = "Y" on a Windows2000 server from VFP6 or VFP7 I only get 345 records. If I set deleted off I get the full 1250 records. However NONE of these records are deleted!
>
>If I run the same query on Windows2000 Pro or Win98 I get the full record set immediately. If I run the query in FoxDos2.6 on the Windows2000 Server I get the full record set.
>
>At first we thought it was because the file didn't have a codepage designated but we fixed that and it still doesn't make a difference. This is happening on two different Windows2000 servers so it's a consistent problem with the file.
---------------------------
Could it be that some (345) of the records have the "Y" as the first character of the field, and the others have it as the second character?
With a proportional font it may "appear" the same...
Try an ALLTRIM() in your SELECT's WHERE clause.