thanks

Hi Evgene, thanks for your answer. Is there a bit missing?

"get the whole answer, sort,and then use..." js??

Thanks

I'd like to sort the results of a query by column X if a value is present in field Y and sort by the value in column Z if a value isn't present in field Y.

Is this possible?

(I know how to sort query results by a single column).

Thanks, Russ

Great, thanks. Don't know how I missed that!