Re: ORDER BY

["Jamadagni, Rajendra" <rajendra.jamadagni@ESPN.COM>]

Chuck,

The sorting is ALWAYS based on the language that you use and character set
that you use. In your case, you want to mix-n-match. This would be difficult
based on my experience. Based on ASCII code, I don't see an easy way to
achieve the order by, as you want it.

Your best bet would be to create a ranking table, which will hold all these
entries and desired rank, then use this ranking table to perform a order by.

HTH
Raj
______________________________________________________
Rajendra Jamadagni              MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !

*********************************************************************

This e-mail message is confidential, intended only for the named recipient(s) 
above and may contain information that is privileged, attorney work product or 
exempt from disclosure under applicable law. If you have received this message 
in error, or are not the named recipient(s), please immediately notify ESPN at 
(860) 766-2000 and delete this e-mail message from your computer, Thank you.

*********************************************************************