Re: "ORDER BY" problems

From: Gary Assa <gsa_at_panix.com>
Date: 1997/07/18
Message-ID: <5qo2dd$fp6@panix.com>#1/1

>For most rows, sort_title is null. But, when it's not null, it's a string
>to be used to establish sorting order instead of title. Thus, title might
>be "The Life and Times of Fred Foobar" and sort_title might be "Life and
>Times of Fred Foobar". Is there any way to say "order by (sort_title if
>it's not null, otherwise by title)"?
>

....
order by nvl(sort_title,title);

-- 
                     ------------------------------------
If you have a condom and sunscreen SPF 15 or greater, than it's safe to look at
                     http://www.panix.com/~gsa/index.html

Received on Fri Jul 18 1997 - 00:00:00 CDT