Re: Q:Sorting titles without the articles.

create another column with what you want to sort on

use something like

set sort_title = ltrim('The ',ltrim('A ',(whole_title))) to lop off beginning The's and A's
be sure to include the space ('The_') or else they'll all start with space

Erwin Meekers <emeekers_at_luc.ac.be> wrote in article <32E714F2.7CCE_at_luc.ac.be>...
> I've a table with titles and I want to sort these titles without the
> articles (a, the, ...). E.g. : "The Oracle Database" should be sorted as
> "Oracle Database"; "A good book" should be sorted as "good book".
>
> I store these articles in a separate table. Is there a kind of SORT BY
> that can solve this problem? We are currently using Oracle 7.2, but we
> will upgrade to 7.3.
>
> When sorting there is another problem : I want to sort special
> characters like "é" (alt + 130) as "e". Is there a kind of option to do
> this too?
>
Received on Sat Jan 25 1997 - 00:00:00 CST