Need advanced SQL statement
Posted in 1998
BT — — source: Informix-list mailing list archive (1991-1998)
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}