Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete Field Value 1

Status
Not open for further replies.

HamOnRye

MIS
Feb 6, 2008
1
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top