Subject Re: [IBO] FB 2.0 com IBO 4.7.16 - Order of the null fields
Author Paul Vinkenoog
Hello Nelson,

> I don't know it is if the bank or the access component, IBO, but in
> it consults them that I accomplish for a field that has null, I
> register them with null they appear first, before updating it was
> not like this.

I guess you mean: before updating to Firebird 2?

That's right: in Firebird 2 nulls appear at the "smallest" end of the
sort (unless overridden by NULLS FIRST/LAST). In Firebird 1.5 they
appeared at the tail end (unless etc.)

It's not a problem, it's a solution :-)
And you can always override the placement in your ORDER BY clause.

See http://www.firebirdsql.org/manual/nullguide-sorts.html


Hope this helps,
Paul Vinkenoog