T tubar Registered User. Local time Yesterday, 18:22 Joined Jul 13, 2006 Messages 190 Mar 21, 2012 #1 i would like to update a field in my update querry to clear its data...i tried NULL in the update to but it didnt work.
i would like to update a field in my update querry to clear its data...i tried NULL in the update to but it didnt work.
P PNGBill Win10 Office Pro 2016 Local time Today, 13:22 Joined Jul 15, 2008 Messages 2,269 Mar 21, 2012 #2 Will Update to "" be acceptable ? There is a difference between Null and "" but vissually they are the same.
Will Update to "" be acceptable ? There is a difference between Null and "" but vissually they are the same.
T tubar Registered User. Local time Yesterday, 18:22 Joined Jul 13, 2006 Messages 190 Mar 21, 2012 #3 it doesnt work due to type conversion failure...the field is a memo.
