Hello,

Am 10.09.2011 23:48, schrieb Vander Clock Stephane:

> the only way i found for now is that when they sort to add a value
>
> "where xxx is not null"
>
> i things that programatiquelly it's can not be so hard to add in
> firebird the functionnality to use index and also put nul value at the end
>

what happens if you do something like this:

select xxx from yourtable where not xxx is null
union all
select xxx from yourtable where xxx is null

This way FB should be able to use the Index and it should return the
rows in the order you want?


[Non-text portions of this message have been removed]