how to clear database SQL server 2005

Question

I'm a new learner..Please our member tell me how to write script to Clear data in a specific column ?
Example In table TblStudent(ID, Name, Sex,Address)...
I want to Clean all record in column address..Please help me..
( I Use Sqlserver 2005 databae and C# 2005 application)

Albertto Lie · Answer

maybe this help.. update TblStudent set address = null this will hit all record because no criteria given.

Loeurt · Answer

thank you so much..

Subramanyam Rompicherla · Answer

Hi below script will be helpful for this problem use the Update command for clean a particular column data. Update your-tablename set delete-column = null; if you have any issues please let me know