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