SQLQuery in read() always sorts null values first

edit

Hi,

When I run this query in the space browser of the GigaSpaces Management Center:

select uid,* from Unit where location = '01' and customer = '6031' order by unitModel desc

Rows with a null value in unitModel always display first regardless of the (desc/asc) in the order by clause.

Is there a way to control this behavior? I would like null values to always sort lowest (first if asc/ last if desc).

Thanks, Jackie

{quote}This thread was imported from the previous forum. For your reference, the original is [available here|http://forum.openspaces.org/thread.jspa?threadID=2743]{quote}