From cec266740d89b82ce9075954928c5b336d0ec18e Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 23 Mar 2004 00:06:08 +0000 Subject: [PATCH] fix sorting of NULL companies differently than empty companies --- httemplate/search/report_receivables.cgi | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi index ad353a1b3..0e95ad73c 100755 --- a/httemplate/search/report_receivables.cgi +++ b/httemplate/search/report_receivables.cgi @@ -93,7 +93,7 @@ where 0 < ,0 ) -order by lower(company), lower(last) +order by coalesce(lower(company), ''), lower(last) END -- 2.11.0