DELETE FROM MyTable WHERE Empty(MsgTime)
HTH
>I have a DATETIME field in a table. Some values are blank. I.e.
>
> / / : : AM
>
>If I want to delete records with this value using SQL DELETE how do I specify the WHERE clause. I.e.
>
>DELETE FROM MyTable WHERE MsgTime = ???????