I've created a database and imported data from a Lotus Notes database. There are a couple of time fields in the database and every record that had an empty field in Lotus Notes shows up as 12:00:00 AM in my new database. I would like to delete all these values so the field is empty (change the value from 0 to empty). I've tried UPDATE but don't know what to update to. I tried "update table set field = "" where field = "00:00:00";" but that had no affect.
What is the correct syntax or is this the wrong command?
Thanks.
What is the correct syntax or is this the wrong command?
Thanks.