On 2-9-2011 19:21, Vander Clock Stephane wrote: > unfortunatly > > If you override the default NULLs placement, no index will be used for > sorting. In Firebird 1.5, > that is the case with NULLS FIRST. In 2.0 and higher, with NULLS LAST on > ascending and > NULLS FIRST on descending sorts. > > but i need the index :(
Then you will need to make changes so there is no NULL value but something which is sortable, or accept that NULLs will be first, or leave out the records with NULL and query them separately. Mark -- Mark Rotteveel
