Post reply

How to delete data from a field

  • 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

  • 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

  • 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.

  • November 12, 2006 at 8:20 am

    #671243

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply