Temp method sort question

[jda]

>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
>

Yes, but if ff is NULL this will be ORDER BY NULL (as opposed to 
ORDER BY FIELD).

But OK, no error.

Jon