Temp method sort question

[Ruslan Zasukhin]

On 3/15/05 11:58 PM, "jda" <jda at his.com> wrote:

>> 
>>>   select *,theDateSortMethod,COALESCE(authors,editors,title) as 'ff'
>>> from thereferences where hit>0 ORDER BY ff,theDateSortMethod
>>> 
> 
> Hi Ruslan,
> 
> I've been reading up on COALESCE. If all the fields are NULL, the
> return is NULL. Is that going to cause a problem with Valentina if
> you try to sort by a NULL field as above? Or will V just ignore it?

NULL values go to the top of selection.
As usual

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------