>I have date fields that have null values. I wish to return a data set of records of this type.
>
>

>SELECT * FROM MyTable WHERE MyDate = NULL
>

Select fieldList from MyTable
where (mydate is null
or mydate < '1-1-1901')

this will find the correct null values and the inproper date crap from VFP stuffing spaces between some curly brackets { }

VFP and dates are the worst thing to contend with outside of VFP.