I'm searching through SQL logs and want to find lines that have WHERE-less (unbounded) queries. I can't come up with a regex to say: SELECT.*FROM.*(the word WHERE must not exist anywhere in the remainder of the line) Am I forgetting something simple or would this take two passes? Alan