How to delete data from a field

• David Greene-305730

  Old Hand

  Points: 390

  More actions

  November 9, 2006 at 9:42 am

  #175350

  Hello everyone,

  I have abaout 3000 records where the data in one field of each record needs to be deleted.

  How do I do this without deleting the entire record?

  Thanks,

  Dave

• ijaz

  SSCommitted

  Points: 1912

  More actions

  November 9, 2006 at 9:49 am

  #670885

  Hi,

  You should need to update that field value with the required by you...

  UPDATE TABLE1 SET RequiredField = NULL

  WHERE Condition = BLA BLA...

   

  Thanks.. I hope this will slove your problem

  cheers

• [KH]

  SSCommitted

  Points: 1908

  More actions

  November 12, 2006 at 8:07 am

  #671242

  You got the concept wrong. A tabel contains many rows. Each rows contains many columns of value. You can't 'delete' a field value. You can only UPDATE it to the value you want.

• David Greene-305730

  Old Hand

  Points: 390

  More actions

  November 12, 2006 at 8:20 am

  #671243

  Thanks guys... I updated the field to NULL.