Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Location
    Kalamazoo
    Posts
    42

    Unanswered: Delete Records!!!

    Hi,
    I am trying to delete records from a table when a specified column encounters null values in them. Could you please let me know how!
    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to your other post in this forum.

    You can use DELETE FROM tablename WHERE Columnname=null and refer to books online for more information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Sep 2003
    Posts
    39
    columnname is null

    instead of columnname = null

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Oh yeah, thanks for the make-up.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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