|
|
Posted by usenet on 10/01/05 17:23
On Fri, 30 Sep 2005 23:21:36 -0400, Bob Stearns <rstearns1241@charter.net>
wrote:
>usenet@isotopeREEMOOVEmedia.com wrote:
>> I need to perform what I'm calling a "conditional sort," and can't figure out
>> how to do it despite lots of time spent with Google, the documentation, and the
>> group archive. I'm sure there's a way to do this, but I suspect that I'm not
>> looking in the correct direction.
>>
>> I need to sort data from a query based on a combination of two fields in a
>> single table.
>> <snip>
>
>ORDER BY COALESCE(name1, name2)
Bob, your check is in the mail. <g> Thanks so much; I never took notice of
that option before.
And as expected, I wasn't looking at the right part of the documentation. But I
sure did learn a lot along the way!
Thanks again.
Navigation:
[Reply to this message]
|