I have a SQL statement..
Dim str As String = "UPDATE tExpress SET dtBagReturned = '" & lDate & "' WHERE iCustomerID = " & lnCustomerID
I only want to update the table if dtBagReturned is empty...how would the syntax look for a null date field in a SQL server database..
Somebody me told a empty date field defaults to a value of # 01/01/01 12:00:00 AM #...so it is not realy empty..
I'm confused on how to change my sql to reflect the " empty" date field
Anyhelp or insight would be much appreciated...