Hi Bob,

It's not going to work because VFP couldn't determine the type of the first field (EVL) if date is empty in the first record.

CREATE CURSOR test ( kk int, dt date )
INSERT INTO test VALUES(1, {})
INSERT INTO test VALUES(2, DATE())
SELECT EVL(dt, Null), kk FROM test     && Generates Error
* If date isn't empty in the first record, it works
CREATE CURSOR test ( kk int, dt date )
INSERT INTO test VALUES(2, DATE())
INSERT INTO test VALUES(1, {})
SELECT EVL(dt, Null), kk FROM test

Bottom line is, you wouldn't want to use it because it may or may not work.

>
>I assume the new OLE-DB provider will support the new EVL() function that is in VFP 8.0. If so, you can just wrap all your dates with it in your selects...
>
>SELECT evl(DateField,null), field2, ...
>
>BOb