convert EMPTY fields to NULL?

[John Sundar]

how to insert null to an EMPTY cell in SQL SERVER... i.e, in a field, i enter some values and deleted it. so, it is considered as EMPTY field and not null. i need a query to make that field <NULL> can anyone help me? - KARAN

[Krish KP]

UPDATE SET = NULL WHERE LEN() = 0 this works for string data even recollect reading IsEmpty() function in SQL Server you may even try with this. I've never used this function.

Regards KP

[Krish KP]

UPDATE TableA SET ColA = NULL WHERE LEN(ColA) = 0 this works for string data even recollect reading IsEmpty() function in SQL Server you may even try with this. I've never used this function.

Regards KP

[SeeSharp 0]

This solution is when you are manually putting data in the fields rom enterprise manager. Just click on the cell and do " control 0 ". That is press control key and zero. this will get NULL value in the empty field. -Naina

--Here 2 See Sharp-- I have not failed. I've just found 10,000 ways that won't work. :)

[John Sundar]

thanks seesharp...but i need it programmatically

[John Sundar]

thanks a lot krish-KP... can i have it for DATETIME field also? i.e.. when the DATETIME field is EMPTY or 1/1/1900, it should be of . how to achieve it? - KARAN