Remove null value from a specific field from SQL 2005 databse

Question

I HAVE A TABLE NAMED ANIL AND A FIELD IN IT I STATUS AND I WANT TO REMOVE NULL FROM THAT FIELD. I DID IT MANUALLY BUT MY DATABASE IS INCREASING AND FACING TROUBLE TO MANUALLY REMOVE IT

---

I am a System Administrator at Vadodara

Answer 1

Can you explain how you remove the NULL manually? Do you use a query? If yes, then please post your query.

---

ClayM

Answer 2

Hi Baiju EP, 

It seems that you want to update the Status with other values, if in this case, you can using T-SQL like below:

Update ANIL Set STATUS ='the vaule you needed' Where STATUS Is Null

Thanks,
Eileen

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.