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]
