How do i update the smalldatetime field to null?

Hi, How do I update my column of type smalldatetime to null. When I am saying set enddate='' It is inserting 1/1/1900 instead of just putting null value there?? Any ideas?? Thanks in advance. Sudheer Chakka __ Struct

Re: How do i update the smalldatetime field to null?

set enddate=NULL with no quotes around null Jerry Johnson >>> [EMAIL PROTECTED] 04/01/02 11:33AM >>> Hi, How do I update my column of type smalldatetime to null. When I am saying set enddate='' It is inserting 1/1/1900 instead of just putting null value there?? Any ideas?? Thanks in