Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sql query to filter out prepositions ie. 'the, a ...'
I've owned both a retail book business and a book wholesaler as well.
Unless it's too late, you should really do what the rest of the industry
does and not use leading articles in your title data. "The Lord of the
Rings" is entered as "Lord of the Rings" or "Lord of the Rings (The)" in the
title field. Including the leading articles will put you out of sync with
an entire industry. Data gathered from any other source will not match what
you have and will require you to recast it in your own format. And there
will be times when you want the leading word to be A or The, i.e. "A is for
Apple, B is for Ball"
"Hans Forbrich" <forbrich_at_telusplanet.net> wrote in message
news:3E7FA4DA.AB1CC95D_at_telusplanet.net...
> You just might want to check out Oracle's native Text solution, variously
> known as Oracle Text or Intermedia Text or other things with the word
> 'Text' in them. Last I checked it was part of the base software, so not
> separate licensing required. Also has additional 'Google search-like'
> capabilities. A secondary thing to look at is UltraSearch, included
> (AFAIK) since 9i. All well documented, relatively easy to install,
> reasonably easy to maintain.
>
> /Hans
>
>
>
Received on Tue Mar 25 2003 - 17:49:26 CST