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" <[email protected] <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 [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
