deleting all the records of a particular field in sql server 2005

[vijaybhasker]

Hi. I'm new to sql server 2005. I want to delete all the records of a particular field in a table. Can anyone tell me how to do it.

[Usharva]

Delete Table YourTable Where Column1='UrCondition'

[Vineeta Agarwal]

I think u want to delete the particular column value only..... do not want to delete all records...... UPDATE tbl_name SET col_name=NULL; it will delete all values of that particular column.