>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.