Posted 8 September 2017, 3:14 pm ESTA customer has data returned from a database that contains a VARCHAR (ie. string) column.
When he sorts on that column it puts rows that contain only spaces first [as expected] but it puts 'empty' strings last [not expected].
I read somewhere in the forum that nulls sort last - but there is a difference between nulls and empty strings.
All the different vendor databases I have tested with sort empty strings first - similar to spaces.
(Nulls can sometimes be specified to sort First or Last as required ... but that has no effect on the order of empty strings.)
Is this a bug in Spread or was it intentional? (if so, why?)
Note that this is Spread 7.