The resultset contains fields from two joined tables. The result field from the joined table is a varchar.
a) If there is a match on ID between the two tables and the field has a value, the value is returned b) If there is a match on ID between the two tables and the field has no value, the value returned is an empty string c) If theere is no match on ID between the two tables, the returned value is <null> I would like to have b) and c) to return the same result so they would sort equaly. regards, Rinse Op donderdag 18 juni 2015 18:33:10 UTC+2 schreef Rami Ojares: > > What do you mean by "empty fields? > On 18 Jun 2015 19:29, "Rinse Lemstra" <r.le...@xso.nl <javascript:>> > wrote: > >> >> Now empty fields and <null> values are sorted in two groups. >> >> Is there a setting or command to let both values sort equaly ? >> >> regards, >> >> Rinse >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to h2-database...@googlegroups.com <javascript:>. >> To post to this group, send email to h2-da...@googlegroups.com >> <javascript:>. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
