OConn = CREATEOBJECT("ADODB.Connection") OConn.ConnectionString = "provider=vfpoledb.1;; data source=c:\\mydata\;Exclusive=false;Nulls=false" OConn.Open cSQL = "select id, name, IIF(EMPTY(date1), null, date1) AS date1 from mytable WHERE id = myid' ORDER BY id" &&does not work cSQL = "select id, name, IIF(EMPTY(date1), {}, date1) AS date1 from mytable WHERE id = myid' ORDER BY id" &&Date1 = 12/30/1899 oRS = OConn.Execute (cSQL) oRS.Close OConn.CloseThanks,