By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,661 Members | 1,330 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,661 IT Pros & Developers. It's quick & easy.

sort ignoring the, a, ...

P: n/a
Is there a way to sort results as follows?

The Acme Company
A Boat Company

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

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******

Nov 11 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
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 pe*****
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.