Hi!

DELETE FROM MyTable WHERE MsgTime = {}

should work fine. If it will cause incorrect date format error, use SET STRICTDATE command.


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