Thread: sort ignoring the, a, ...

sort ignoring the, a, ...

From
CSN
Date:
Is there a way to sort results as follows?

Acme
The Acme Company
Beer
A Boat Company
Boats
Cars
...

i.e., ignoring leading the's, a's, etc.?

TIA,
CSN


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

Re: sort ignoring the, a, ...

From
Peter Eisentraut
Date:
CSN writes:

> Is there a way to sort results as follows?

> i.e., ignoring leading the's, a's, etc.?

Not built in.  You'll need to use some kind of pattern matching to strip
off the leading articles.

--
Peter Eisentraut   peter_e@gmx.net