How to Store NULL in datetime datatype

Vajrala Narendra

Hi am working with asp.net with backend Sql2000

i want to store NULL in datetime datatype field through coding. i wrote a update statement as
Update table set Date1='NULL' where ........
but while updating it is giving error converting varchar to datetime

how to store NULL in that field
please respond

Thanks in Advance

r035198x

Don't put the quotes around NULL. The quotes are the ones making it a string.

How to Store NULL in datetime datatype

re: How to Store NULL in datetime datatype

Similar .NET Framework bytes

/bytes/development

/bytes/it

/bytes/about