Classic ASP Discussion - exclude term search

Print Page | Close Window

exclude term search

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=13065
Printed Date: 28 March 2026 at 3:11pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: exclude term search

Posted By: Lucent
Subject: exclude term search
Date Posted: 20 December 2004 at 11:58pm

Is it possible to do exclude term search in asp?

something like

Search teacher AND education OR school NOT Student

Replies:

Posted By: Mart
Date Posted: 21 December 2004 at 3:12am

I presume you mean with SQL not ASP, your SQL query would look something like:

SELECT * FROM tblSchools WHERE teacher LIKE '%term%' AND education LIKE '%term%' OR school LIKE '%term%' AND NOT student LIKE '%term%'

Posted By: Lucent
Date Posted: 21 December 2004 at 12:29pm

How can I do this in the search form?

Keywords:_____________

Excluding keywords:____________