Re: zero length string to zero

On 04/20/2016 05:31 AM, Shadi Mal wrote:
> Hi,
>   I get zero length string in my result but I want to have zero value
> instead.
> what can I do?
> my query is:
> SELECT unreadmandatory.id <http://unreadmandatory.id>,
>           Count(unreadmandatory.course) AS nbrofmandatoryleft
>             FROM unreadmandatory
>            GROUP BY unreadmandatory.id <http://unreadmandatory.id>

What is the type of unreadmandatory.id?

And are you getting an empty string or NULL?


--
Adrian Klaver
adrian.klaver@aklaver.com