>Hi Sheena,
>
>First, SET CENTURY won't matter if it's a character field. FoxPro doesn't see it as a date and you can't compare a date with a character. FoxPro 2.6 isn't any different from VFP on this.
>
>Using a character field for a date is, in my opinion, bad design. And especially since there are only 6 characters, there is no place for the century.
>
>So you're going to have to try something like:
>DELETE FOR DATE != "010100"
>
>You'll also have to find out what date format they used, although I'm pretty sure it is DDMMYY.
>
>

---

>>Hello:
>>
>>I've been given a foxpro2.6 table that someone is trying to query on field called date which is 6 characters. I've never used 2.6
>>, I'm using 5 and 6.
>>
>>When they do a delete for date != {01/01/00}
>>it deletes all records with this date , it's not recognizing 00 . Any work around for this? Seems like it's setting to 1900.
>>
>>If I set century on it still doesn't do the query. Any input would be appreciated.
>>THanks.
>>
>>Sheena


Thanks,

I just inheritied it, didn't design.

I'll try what you suggested.