>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 = ???????
>
>Many thanks.
If you don't like Larry and Sylvain's way, you can use:
... WHERE MsgTime={//:}