This caused the rows with a blank date1 to be entirely NULL while the other rows were OK.

Any other ideas?

Thanks



>How about:
>

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