SQL script, how to clear a date field

RoelofRoelof Member Posts: 377
I'm currently writing a SQL script to clear a date field of a NAV table. If I clear it as a blank it will give me a weird sql date format and I'm not able to run the table or record. Any idea how to do this? PS: a 'NULL' value or 0 doesn't work either.
Roelof de Jonghttp://www.wye.com


Sign In or Register to comment.