Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Posts
    2

    Unanswered: Find and Delete rows with less than 100 characters

    Hi,

    I'm working with a database that has one column that contains rows with verbatim (text). I want to delete each row that has less than 100 characters. How would I write this query?

    Any help is appreciated!
    Thank you,
    Patrik

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    whoa, this is a tricky one

    j/k


    Code:
    DELETE 
      FROM daTable
     WHERE LENGTH(daColumn) < 100
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2010
    Posts
    2
    Awesome; thank you! Not easy for us non-techs...
    -P

Tags for this Thread

Posting Permissions

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