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