Deleting Selective Rows from Table

• kreskins

  Default port

  Points: 1429

  More actions

  December 10, 2002 at 1:15 pm

  #105930

  I want to delete say 500 select rows in a table. There is a unique column called "pacode". I would like to do something like:

  Delete TABLE_NAME where pacode= 'a' , 'b' , 'c'...etc

  or

  pacode is one of: a, b, c, d....etc

  I could not find correct syntax for SQL 6.5

  Thanks For your continued Help.

  
  Thanks For your continued Help.

• Michael S. Armentrout

  Ten Centuries

  Points: 1178

  More actions

  December 10, 2002 at 1:36 pm

  #443980

  Try:

  DELETE TABLE_NAME

  WHERE pacode IN ('a','b','c','d')

  Be great!

  Michael

  
  Be great!
  Michael

• don1941

  SSCarpal Tunnel

  Points: 4183

  More actions

  December 10, 2002 at 1:56 pm

  #443983

  delete

  ...

  where code = 'a'

  or code='b'

  or code='c'

  works too.