fix sorting of NULL companies differently than empty companies
authorivan <ivan>
Tue, 23 Mar 2004 00:06:08 +0000 (00:06 +0000)
committerivan <ivan>
Tue, 23 Mar 2004 00:06:08 +0000 (00:06 +0000)
httemplate/search/report_receivables.cgi

index ad353a1..0e95ad7 100755 (executable)
@@ -93,7 +93,7 @@ where 0 <
            ,0
          )
 
-order by lower(company), lower(last)
+order by coalesce(lower(company), ''), lower(last)
 
 END