Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> sql query to filter out prepositions ie. 'the, a ...'

sql query to filter out prepositions ie. 'the, a ...'

From: Barnoit <jbarney_ca_at_yahoo.ca>
Date: 24 Mar 2003 10:09:19 -0800
Message-ID: <cd2c60c8.0303241009.54d25b50@posting.google.com>


I'm trying to write a query that does a search on the first letter in a column. That part is ok, ie:

select book_title
from books
where UPPER(substr(book_title,1,1)) = 'A';

But some book titles might be 'The Lord of the Rings' or 'A Nightmare...', so I'd only want the query to do the search on the actual name. I would have a reasonably short list of those prepositions I'd want to trim off. Received on Mon Mar 24 2003 - 12:09:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US