Post reply

Delete bad data

  • April 13, 2007 at 6:33 am

    #177347

    How can I delete some bad data in a particular column, i am able to select those rows but how can i delete just a column selected.

     for example my select statement goes like this..

     

    select jobfrom emp where descr LIKE 'x34f%'

  • April 13, 2007 at 7:59 am

    #700359

    Just to make sure I understand correctly : You want to remove the data in a particular column but without deleting the entire row and without dropping the column?

     

    If those are all "yes" then this should do it (test in developpement first) :

    This statement sets the job column to null.  If this is not what you want and still need help, just come back and we'll clear it up for you.

    update E SET E.job = NULL from Emp E where E.descr LIKE 'x34f%'

Viewing 2 posts - 1 through 1 (of 1 total)

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