$sth=$dbh->prepare(qq{SELECT title,books.author,notes,books.titleid,pubyear,books.authorid FROM books WHERE notes like ? ORDER BY lower(title)}) or die "Couldn't prepare your statement: " . $dbh->errstr; $sth->execute("%$Notes%") or die "Couldn't execute your statement: " . $sth->errstr;