Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005
    Posts
    74

    Unanswered: Delete blank column

    hi! can anybody please help me..i have a table employee and it has 4 column namely id,lastname,firstname,salary and i want to delete all rows where firstname is equal to blank or ' ' NULL? thanks a bunch!

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    DELETE FROM employee
    WHERE firstname IS NULL
    OR firstname = ' ';

  3. #3
    Join Date
    Sep 2005
    Posts
    74
    thanks so much!!

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i call homework
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •