>This caused the rows with a blank date1 to be entirely NULL while the other rows were OK.
>
>Any other ideas?
>
>Thanks
>

What do you mean here? Also, why do you need Nulls = 'true' in the connection string?

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