subject:"\[GENERAL\] zero length string to zero"

Re: [GENERAL] zero length string to zero

2016-04-21 Thread Adrian Klaver

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 , Count(unreadmandatory.course) AS nbrofmandatoryleft FROM unreadmanda

[GENERAL] zero length string to zero

2016-04-21 Thread Shadi Mal

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, Count(unreadmandatory.course) AS nbrofmandatoryleft FROM unreadmandatory GROUP BY unreadmandatory.id