Need advanced SQL statement

From: BT <brett_at_travelersonline.com>
Date: 1998/12/23
Message-ID: <75s4m4$6d230_at_news.orconet.com>#1/1


I'm looking for an advanced SQL statement that will work with any ASCII compliant database engine. Also the pre-parser to set the string up to be searched.

If you have seen http://www.DejaNews.com in action, much like that.

Looking for anything like this or where I may find it ?

Thanks - Brett.

---

Something that will handle the following - or close to it.

&  - AND           e.g. beans & rice
|  - OR                camel | llama
&! - AND NOT           clam &! chowder
^  - NEAR              lucas ^ spielberg

  Keywords can be combined with the following symbols:

"..." - Quote Marks    "the far side"
  *   - Wildcard       psych*
(...) - Parentheses    scully & (xfiles | x-files)
{...} - Braces         {monkey monkeying}
Received on Wed Dec 23 1998 - 00:00:00 CET

Original text of this message