Temp method sort question

jda jda at his.com
Tue Mar 15 16:58:03 CST 2005


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

Jon


More information about the Valentina-beta mailing list